Thread: How to reset sequences on pre-7.1
Hi, I usually use a: SELECT setval('seq_name', NULL); to reset sequences, so the next time it's called it returns '1'. This works in all Pg releases I've ever tested but 7.0. On an hosted space that still has a 7.0 release candidate, this query fails, telling me that I cannot use a 0 value. Anybody knows how to reset sequences in this case? Regards -- Matteo Beccati http://www.phpadsnew.com http://phppgads.sourceforge.net
"Matteo Beccati" <m.beccati@crpsoftware.it> writes: > I usually use a: > SELECT setval('seq_name', NULL); > to reset sequences, so the next time it's called it returns '1'. This > works in all Pg releases I've ever tested but 7.0. On all recent releases, that is a complete no-op, because setval() is a strict function. Better check what you were actually doing. regards, tom lane