[Koha] mysql to postgresql

[Marco Gaiarin]

Mandi! Christian Calle
  In chel di` si favelave...

> I am migrating the BD mysq Koha to Postgresql, I want to saver if somebody 
> had that experience, 
> I am beginning to modify the copy that I did of the SQL of mysql.  To load 
> to poststoneware and to modify the access of the DBI with the Perl.  

I've also thinked about porting koha to postgres, and AFAIK it is
planned in some future release... the problem are not on perl side,
where dbi do an exellent work, but on schema and SQL dialects.

MySQL accept rather all identifier for field and table name, where
postgres are more clever and define as reserved all the SQL92
identifier (as standard say) and some more.
So, it is needed to change the schema, because there's no way to create
a field name ``user'' or ``desc'' in postgres, for example...

The second big problem came again from the bad adherence of mysql to
the SQL standards: MySQL accept rather all SQL syntiax (sometime
ignoring it ;) but have some custom instructions like... mumble... i
don't remember, could be ADD? In any case, an instruction that alter a
record, if present, or insert if not.


So i think that porting koha to postgres will be a very cool feature,
but expect to:

1) alter the schema
2) alter some sql instruction (for 1)
3) alter the code to substitute a non-standard sql instruction with
  some standard ones, plus some code.


Good luck. ;)

-- 
dott. Marco Gaiarin				    GNUPG Key ID: 240A3D66
  Associazione ``La Nostra Famiglia''                http://www.sv.lnf.it/
  Polo FVG  -  Via della Bontà, 7 - 33078  -  San Vito al Tagliamento (PN)
  gaio(at)sv.lnf.it		tel +39-0434-842711    fax +39-0434-842797

    ... votantoniovotantoniovotantoniovotantoniovotantoniovotantonio ...
	     resistenza arcobaleno contro la politica grigia

		    http://www.peacelink.it/votantonio