From: | Jayadevan M <maymala(dot)jayadevan(at)gmail(dot)com> |
---|---|
To: | loc <c320sky(at)gmail(dot)com> |
Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Insert zero to auto increment serial column |
Date: | 2014-04-02 12:53:46 |
Message-ID: | CAFS1N4hw9o99J4PP0vi7KUFJ3UF44CxEFutde4gjeS2_DqSzsw@mail.gmail.com |
Views: | Whole Thread | Raw Message | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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.
>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Scott Marlowe | 2014-04-02 13:24:39 | Re: Insert zero to auto increment serial column |
Previous Message | Albe Laurenz | 2014-04-02 12:49:15 | Re: Insert zero to auto increment serial column |