Skip site navigation (1) Skip section navigation (2)

Re: Auto-incrementing field

From: Aarni Ruuhimäki / Megative Tmi / KYMI(dot)com <aarni(dot)ruuhimaki(at)kymi(dot)com>
To: "Jim Steil" <jim(dot)steil(at)customcall(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Auto-incrementing field
Date: 2002-07-29 16:53:41
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
Hi !

Please consider using a scriplet of your own for the locking db, getting e.g. 
the max id +1 as your next increment, inserting the record (probably only 
with the new id) and then unlock the db.

Sometimes it is worth because auto-increment as index migth get you into 
trouble in certain situations. Or if you get into an other sort of bad 
situation with corrupted data, having used auto-increment as index will 
double your trouble or your work amount atleast.



On Friday 26 July 2002 10:49 pm, you wrote:
> Is there a data type in PostgreSQL that will 'auto-increment'?  I have used
> this in MS SQL Server in the past and would like to continue to do so with
> PostgreSQL.  Thanks for any help...
> 	-Jim
> Jim Steil
> CustomCall Data Systems
> (608) 274-3009
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly

In response to

pgsql-novice by date

Next:From: denisDate: 2002-07-30 05:10:27
Subject: Re: Trigger question
Previous:From: Jillian CarrollDate: 2002-07-29 16:14:32
Subject: Altering psqlodbc.h

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group