| From: | tgl(at)postgresql(dot)org (Tom Lane) |
|---|---|
| To: | pgsql-committers(at)postgresql(dot)org |
| Subject: | pgsql: Fix ALTER SEQUENCE so that it does not affect the value of |
| Date: | 2007-10-25 18:54:04 |
| Message-ID: | 20071025185404.11A20754229@cvs.postgresql.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-committers |
Log Message:
-----------
Fix ALTER SEQUENCE so that it does not affect the value of currval() for
the sequence. Also, make setval() with is_called = false not affect the
currval state, either. Per report from Kris Jurka that an implicit
ALTER SEQUENCE OWNED BY unexpectedly caused currval() to become valid.
Since this isn't 100% backwards compatible, it will go into HEAD only;
I'll put a more limited patch into 8.2.
Modified Files:
--------------
pgsql/doc/src/sgml:
func.sgml (r1.404 -> r1.405)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/func.sgml?r1=1.404&r2=1.405)
pgsql/doc/src/sgml/ref:
alter_sequence.sgml (r1.18 -> r1.19)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/ref/alter_sequence.sgml?r1=1.18&r2=1.19)
pgsql/src/backend/commands:
sequence.c (r1.146 -> r1.147)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/commands/sequence.c?r1=1.146&r2=1.147)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2007-10-25 19:13:37 | pgsql: Fix memory management for new variables -- they must actually |
| Previous Message | Andrew Dunstan | 2007-10-25 17:51:16 | Re: [HACKERS] Re: pgsql: Extract catalog info for error reporting before an error actually |