Ludwig Lim wrote: > --- Ricardo Javier Aranibar León > <[EMAIL PROTECTED]> 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);
That will probably set the current value to 1, which will result in a nextval of 2, which is perhaps not what Ricardo wanted. > Maybe setval(<text>,<bigint>,<bool>) doesn't exist in > 7.0.3. \df setval in psql should output all possible parameter combinations for setval. Regards, Michael Paesold ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])