convertsql INFORMIX POSTGRES8

John O'Gorman <[email protected]>
Newsgroups gmane.comp.lang.4gl.aubit.general
Organization OCCL
Message-ID <[email protected]>
Hi everyone.

I've got another potential project converting a legacy RDS application 
into PG.

I've fallen at the first hurdle - converting the export .sql file into 
pg syntax.
There are 58 tables but only 28 converted OK.
The most obvious failures are those with serial primary key columns 
which export with a constraint expression.
Removing the constraint expression allows the table to be converted.

This is not a show-stopper, as I can edit the file to remove the contraints.
But it may be that this is fixed in the current version of Aubit4GL.
I am using version 1.2_14

John O'Gorman

------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and 
threat landscape has changed and how IT managers can respond. Discussions 
will include endpoint security, mobile security and the latest in malware 
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.