Re: Auto-incrementing field - Mailing list pgsql-novice

From AarniRuuhimäki / Megative Tmi / KYMI.com
Subject Re: Auto-incrementing field
Date
Msg-id 20020729165554.QVBM3204.fep06.tmt.tele.fi@there
Whole thread Raw
In response to Auto-incrementing field  ("Jim Steil" <jim.steil@customcall.com>)
List 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.

BR,


aarni


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@postgresql.org so that your
> message can get through to the mailing list cleanly


pgsql-novice by date:

Previous
From: "Jillian Carroll"
Date:
Subject: Altering psqlodbc.h
Next
From: denis@coralindia.com
Date:
Subject: Re: Trigger question