X-Original-To: pgsql-admin@postgresql.org
Received: from spampd.localdomain (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP
	id DB924475AE4; Sat, 19 Apr 2003 11:51:31 -0400 (EDT)
Received: from sss.pgh.pa.us (unknown [192.204.191.242])
	by postgresql.org (Postfix) with ESMTP
	id 1F62B4758C9; Sat, 19 Apr 2003 11:51:31 -0400 (EDT)
Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1])
	by sss.pgh.pa.us (8.12.9/8.12.9) with ESMTP id h3JFpHU6021919;
	Sat, 19 Apr 2003 11:51:18 -0400 (EDT)
To: "Edipo E. F. Melo" <edipoelder@ig.com.br>
Cc: "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>,
	"pgsql-sql" <pgsql-sql@postgresql.org>
Subject: Re: Where is the sequence value? 
In-reply-to: <20030419114606.564CD4758C9@postgresql.org> 
References: <20030419114606.564CD4758C9@postgresql.org>
Comments: In-reply-to "Edipo E. F. Melo" <edipoelder@ig.com.br>
	message dated "Sat, 19 Apr 2003 08:50:06 -0300"
Date: Sat, 19 Apr 2003 11:51:17 -0400
Message-ID: <21918.1050767477@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
X-Spam-Status: No, hits=-29.1 required=5.0
	tests=BAYES_00,EMAIL_ATTRIBUTION,IN_REP_TO,REFERENCES,
	REPLY_WITH_QUOTES autolearn=ham	version=2.50
X-Spam-Level: 
X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp)
X-Archive-Number: 200304/276
X-Sequence-Number: 8431

"Edipo E. F. Melo" <edipoelder@ig.com.br> writes:
>    So, I set i to 1 ("setval('seq', 1)"), but in my system, when I try to insert a process, the nextval
> () returns 2, not 1. 

You need to clear the is_called flag too.  See the three-parameter form
of setval():
http://www.ca.postgresql.org/users-lounge/docs/7.3/postgres/functions-sequence.html

			regards, tom lane