Re: Migrating Informix to PostgreSQL

Andrej Falout wrote: >Guys; > >There is Informix compatibility patch for PG and ecpg compiler: > >http://gborg.postgresql.org/project/pginformix/projdisplay.php > >There is allready patched code available from: > >http://informix.fastcrypt.com/ > >Older RPM's: > >http://informix.postgresintl.com/ > >We are using them as part of Aubit 4GL compiler project. > >There is at least one company that is using them in production >situation. > >HTH, >Andrej Falout > > > > Thanks for that link. I've thought of two more issues over the weekend but hopefully your link will help: 1) ecpg will not allow you to prepare a statement until you have a database open. This means you cannot determine database at runtime unless you use the core C function to do it. 2) ecpg does not allow arrays of host variables. My boss noticed this so I'm not too sure of any extra details. -- Scott Burns Mirrabooka Systems Tel +61 7 3857 7899 Fax +61 7 3857 1368