reset sequence - Mailing list pgsql-sql

From Ricardo Javier Aranibar León
Subject reset sequence
Date
Msg-id F84StMVhEUsebmspH2q0000197a@hotmail.com
Whole thread Raw
Responses Re: reset sequence  (Ludwig Lim <lud_nowhere_man@yahoo.com>)
List pgsql-sql
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);

Now when I execute this command I have a message ERROR.
"ERROR: Function 'setval(unknow, int4, bool)' does not exist. Unable to 
identify a function that satisfies the given argument types. You may need to 
add explicit typecast".


_________________________________________________________________
MSN. Más Útil cada Día. http://www.msn.es/intmap/



pgsql-sql by date:

Previous
From: Josh Berkus
Date:
Subject: Re: writing a function to mimic mysql last_insert_id
Next
From: "Christopher Kings-Lynne"
Date:
Subject: Re: writing a function to mimic mysql last_insert_id