Postgres Pro
Downloads
Home   >   mailing lists

Thread: Last value of a key sequence

Last value of a key sequence

From
Michael Talbot-Wilson
Date:
The last_value of a key sequence is incremented by pgaccess if I try
to leave a row without entering data in a NOT NULL attribute.

How can I change the last_value of a key_seq?  It doesn't work to
treat the sequence as a table and try to update it with SQL.