Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: PLEASE help ME , HOW TO GENERATE PRIMARY Keys on the fly
- From: Andrew Sullivan <ajs(at)crankycanuck(dot)ca>
- To: pgsql-sql(at)postgresql(dot)org
- Cc: Bruno Wolff III <bruno(at)wolff(dot)to>, Andrew Sullivan <ajs(at)crankycanuck(dot)ca>
- Subject: Re: PLEASE help ME , HOW TO GENERATE PRIMARY Keys on the fly
- Date: Fri, 26 May 2006 10:22:54 -0400
On Fri, May 26, 2006 at 09:08:20AM -0500, Bruno Wolff III wrote: > > Rollbacks will not reset sequence values. Use setval to do that. No, what I posted was the CREATE SEQUENCE after the BEGIN. ROLLBACK gets rid of the sequence. The next time you create the same sequence, therefore, it also starts at 1. I don't actually know what this ranking is useful for, to be honest, but people ask for it, and this is a stupid Postgres trick that can make it happen. A -- Andrew Sullivan | ajs(at)crankycanuck(dot)ca The plural of anecdote is not data. --Roger Brinner
- References:
- Re: PLEASE help ME , HOW TO GENERATE PRIMARY Keys on the fly
- From: andi
- Re: PLEASE help ME , HOW TO GENERATE PRIMARY Keys on the fly
- From: Andrew Sullivan
- Re: PLEASE help ME , HOW TO GENERATE PRIMARY Keys on the fly
- From: Bruno Wolff III
- Re: PLEASE help ME , HOW TO GENERATE PRIMARY Keys on the fly
- Prev by Date: Re: PLEASE help ME , HOW TO GENERATE PRIMARY Keys on the fly
- Next by Date: Re: PLEASE help ME , HOW TO GENERATE PRIMARY Keys on the fly
- Previous by thread: Re: PLEASE help ME , HOW TO GENERATE PRIMARY Keys on the fly
- Next by thread: Re: PLEASE help ME , HOW TO GENERATE PRIMARY Keys on the fly
- Indexes: