Radicore Forum: How To » Auto Increment PostgreSQL

Home » RADICORE » How To » Auto Increment PostgreSQL

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Re: Auto Increment PostgreSQL [message #4251 is a reply to message #4250]

Wed, 11 June 2014 04:37

AJM
Messages: 2382
Registered: April 2006
Location: Surrey, UK

Senior Member

Something has changed in Postgres as in my test application I used data types of either 'serial' or 'bigserial' to indicate an auto_increment column, but when querying the table it returns the value 'integer' or 'bigint' with the default value set to "nextval('....')".

I attach a copy of the updated Postgres driver. After importing the columns you will have to manually clear the old default value, but it will now set 'auto_increment' to TRUE as it should.

Attachment: dml.pgsql.class.zip
(Size: 14.27KB, Downloaded 1131 times)

Tony Marston
http://www.tonymarston.net
http://www.radicore.org

Report message to a moderator

[Message index]

		Auto Increment PostgreSQL By: kong on Tue, 10 June 2014 08:22
		Re: Auto Increment PostgreSQL By: AJM on Wed, 11 June 2014 04:37
		Re: Auto Increment PostgreSQL By: kong on Fri, 13 June 2014 20:08

Previous Topic:	Creating a List 2 transaction between multiple databases
Next Topic:	How to show tab as an image hyperlink

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Tue Jul 08 16:44:46 EDT 2025

Total time taken to generate the page: 0.00929 seconds