Last value of a key sequence

From: Michael Talbot-Wilson <mtw(at)birdseye(dot)view(dot)net(dot)au>
To: pgsql-general(at)postgresql(dot)org
Subject: Last value of a key sequence
Date: 2000-10-26 23:28:21
Message-ID: Pine.LNX.4.21.0010270857020.22446-100000@chameleon.view.net.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Browse pgsql-general by date

  From Date Subject
Next Message Lamar Owen 2000-10-26 23:34:27 Re: Postgres 7.0.2-2 on Red Hat 7.0?
Previous Message Nikolaus Rumm 2000-10-26 21:19:40 getBigDecimal() in JDBC driver not yet implemented ?