Last value of a key sequence - Mailing list pgsql-general

From Michael Talbot-Wilson
Subject Last value of a key sequence
Date
Msg-id Pine.LNX.4.21.0010270857020.22446-100000@chameleon.view.net.au
Whole thread Raw
List pgsql-general
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.



pgsql-general by date:

Previous
From: David C Mudie
Date:
Subject: Re: PostgreSQL General Digest V1 #764
Next
From: Tom Lane
Date:
Subject: Re: SELECT DISTINCT ON... ORDER BY...