X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [64.117.224.130])
	by svr1.postgresql.org (Postfix) with ESMTP id B377BD1B52A
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Sat, 20 Sep 2003 11:26:21 +0000 (GMT)
Received: from svr1.postgresql.org ([64.117.224.193])
	by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new,
	port 10024) with ESMTP id 22446-06
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Sat, 20 Sep 2003 08:25:52 -0300 (ADT)
Received: from smtp1.gigared.com (unknown [200.68.216.5])
	by svr1.postgresql.org (Postfix) with ESMTP id BD123D1B587
	for <pgsql-sql@postgresql.org>; Sat, 20 Sep 2003 08:25:49 -0300 (ADT)
Received: from 10.41.130.123 (unknown [10.41.130.123])
	by smtp1.gigared.com (Postfix) with SMTP
	id A7706327A0; Sat, 20 Sep 2003 08:17:49 -0300 (GMT)
From: Martin Marques <martin@bugs.unl.edu.ar>
To: "Muhyiddin A.M Hayat" <middink@indo.net.id>,
	<pgsql-sql@postgresql.org>
Subject: Re: auto_increment
Date: Sat, 20 Sep 2003 08:18:17 -0300
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: quoted-printable
Content-Disposition: inline
Message-Id: <200309200818.17347.martin@bugs.unl.edu.ar>
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Archive-Number: 200309/221
X-Sequence-Number: 15199

Why do you want it to rollback?

El S=E1b 20 Sep 2003 05:43, Muhyiddin A.M Hayat escribi=F3:
> Ok, but if i do rollback, the auto_increment don't roolback.
> How to use nextval(), currval() and setval() functions.
>
> ----- Original Message -----
>   From: Cavit Keskin
>   To: 'Muhyiddin A.M Hayat'
>   Sent: Saturday, September 20, 2003 2:15 PM
>   Subject: RE: [SQL] auto_increment
>
>
>   Create table tablename(
>
>     id serial,
>
>     ....
>
>   );

--=20
Porqu=E9 usar una base de datos relacional cualquiera,
si pod=E9s usar PostgreSQL?
-----------------------------------------------------------------
Mart=EDn Marqu=E9s                  |        mmarques@unl.edu.ar
Programador, Administrador, DBA |       Centro de Telematica
                       Universidad Nacional
                            del Litoral
-----------------------------------------------------------------