On 04/02/2014 05:17 AM, loc wrote:
I'm currently using an Informix Innovator-C database with Aubit4GL and I would like to migrate to PostgreSQL, it looks like the transition will not be too difficult, however there is one feature that I would like added to PostgreSQL. Where is the best place to request a feature add? With Informix inserting a 0 into a serial column will auto increment the serial value, MySQL also works this way. With PostgreSQL I will need to do a lot of code modification to my Aubit4GL programs, since I will need to either insert with the key word default or omit the serial column in the insert statement. A typical insert with Aubit4GL looks like this: create table table_name (link serial, col2 integer, col3 integer ....) define var_rec record like table_name.* let table_name.link = 0 insert into table_name values(var_rec.*) As you can see, with Informix the serial column is set to 0 before the insert, with PostgreSQL I will need to list all the columns and will not be able to use the wildcard syntax, which supplies all the column names to the insert. Setting the serial column to null to auto increment would also work for me.
Looks like Aubit4GL has provisions for doing the conversions behind the scenes:
http://aubit4gl.sourceforge.net/aubit4gldoc/manual/index.html and for a more detailed example: http://openssa.sourceforge.net/aubit4gl.html Might be worth asking for more info on the Aubit4GL list: https://lists.sourceforge.net/lists/listinfo/aubit4gl-discuss
-- Adrian Klaver adrian.klaver@xxxxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
