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/ ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster