Search Postgresql Archives

Re: Insert zero to auto increment serial column

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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




[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux