--- 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); 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 ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])