Quick Links

psql sequence question

From:	Jodi Kanter <jkanter(at)virginia(dot)edu>
To:	Postgres Admin List <pgsql-admin(at)postgresql(dot)org>
Subject:	psql sequence question
Date:	2003-06-16 15:24:28
Message-ID:	3EEDE12C.30401@virginia.edu
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-admin

If I'm using transactions (not autocommit), are sequences atomic?

In other words, after inserting a record to a table that
uses sequence A, am I guaranteed that select last_value on
sequence A is atomic, and cannot be interfered with by other
transactions using that same sequence? Sequence A is used by
several tables.

Thanks,
Jodi

_______________________________
Jodi L Kanter
BioInformatics Database Administrator
University of Virginia
(434) 924-2846
jkanter(at)virginia(dot)edu <mailto:jkanter(at)virginia(dot)edu>

Responses

Re: psql sequence question at 2003-06-16 16:04:10 from Bruno Wolff III
Re: psql sequence question at 2003-06-16 18:26:37 from Ernest E Vogelsinger

Browse pgsql-admin by date

	From	Date	Subject
Next Message	Markus Bertheau	2003-06-16 15:27:59	how do I get rid of huge sorttemp files?
Previous Message	Tom Lane	2003-06-16 14:48:06	Re: Move passwords between databases