Re: How to reset sequences on pre-7.1 - Mailing list pgsql-sql

"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