Re: reset sequence - Mailing list pgsql-sql

From Ludwig Lim
Subject Re: reset sequence
Date
Msg-id 20020912101213.18861.qmail@web40014.mail.yahoo.com
Whole thread Raw
In response to reset sequence  (Ricardo Javier Aranibar León<ricardo_jal@hotmail.com>)
List pgsql-sql
--- Ricardo Javier Aranibar Le�n
<ricardo_jal@hotmail.com> wrote:
> Hi List,
> 
> I need that somebody help me.
> First, I use PostgreSQL 7.0.3 for linux.
> I need reset my sequence but that it begin in 1
> again when a use nextval.
> And I have been search in
> http://archives.postgresql.org/ about reset 
> sequence but I obtain this information:
>    SELECT setval('name_sequence', 1, false);

try SELECT setval('name_sequence',1);

Maybe setval(<text>,<bigint>,<bool>) doesn't exist in
7.0.3.

regards,
ludwig lim

__________________________________________________
Do you Yahoo!?
Yahoo! News - Today's headlines
http://news.yahoo.com


pgsql-sql by date:

Previous
From: juerg.rietmann@pup.ch
Date:
Subject: still sorting and casting problems
Next
From: "Michael Paesold"
Date:
Subject: Re: reset sequence