Re: SERIAL Field

From: Joel Stevenson <jstevenson(at)bearriver(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: SERIAL Field
Date: 2002-05-06 20:57:40
Message-ID: a0511170cb8fc9c4efa8b@[192.168.1.100]
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

>
>People who have not studied the documentation frequently make that
>claim. *There is no such risk* (unless A and B are interleaving their
>commands on a single database connection, in which case they have lots
>worse risks of conflicts than this one). See
>http://www.ca.postgresql.org/users-lounge/docs/7.2/postgres/functions-sequence.html
>
> regards, tom lane

Point taken. I've worked on web-apps which use a single JDBC
connection per user session where the overlap could occur, but as you
say there are far greater issues involved for such session-based
connections.
--
Joel Stevenson
Bear River Associates, Inc.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message otisg 2002-05-07 03:47:31 Re: Dying PostgreSQL backend
Previous Message Tom Lane 2002-05-06 20:16:31 Re: SERIAL Field