Re: Insert zero to auto increment serial column

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(dot)klaver(at)aklaver(dot)com