Re: Insert zero to auto increment serial column

Will a rule work?
http://www.postgresql.org/docs/9.3/static/sql-createrule.html

On Wed, Apr 2, 2014 at 5:47 PM, loc <c320sky(at)gmail(dot)com> 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.
>
>
>