From: Richard Huxton <dev@archonet.com>
To: "Muhyiddin A.M Hayat" <middink@indo.net.id>,
	<pgsql-sql@postgresql.org>
Subject: Re: auto_increment
Date: Sat, 20 Sep 2003 11:05:30 +0100
User-Agent: KMail/1.5
References: <001d01c37f3e$983ed3a0$2363a8c0@ckeskin>
	<002201c37f54$29608e40$1f00a8c0@middinkcomp>
In-Reply-To: <002201c37f54$29608e40$1f00a8c0@middinkcomp>
MIME-Version: 1.0
Content-Type: text/plain;
  charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Message-Id: <200309201105.30370.dev@archonet.com>

On Saturday 20 September 2003 09:43, Muhyiddin A.M Hayat wrote:
> Ok, but if i do rollback, the auto_increment don't roolback.

It's not supposed to.

> How to use nextval(), currval() and setval() functions.

Something like:
  INSERT INTO my_table(nextval('my_sequence_name'),'aaa',1);
But you'll get the same problem.

What are you trying to do with the auto-increment? If you want to guarantee 
that the numbers go up in sequence and have no gaps (e.g. 1,2,3,4,5 NOT 
1,2,4,6) then you'll need to do some more work.

Think about what you want to have happen when three clients insert rows at the 
same time and one rolls back. Once you've decided what you want, ask again if 
you need some help.

-- 
  Richard Huxton
  Archonet Ltd