[EMAIL PROTECTED] writes:
> After upgrading from v. 721 to 723 some of regression tests failed.
> BEGIN;
> CREATE SEQUENCE s_ASeq;
> SELECT nextval('s_ASeq') ;
> DROP SEQUENCE s_ASeq ;
> /* some sql statement might be here */
> COMMIT;
> 1) Problem occurs when attempt is made to drop the sequence:
> ERROR: RelationForgetRelation: relation <rel_no> is still open
Yes; 7.2.3 will basically not let you drop a sequence that was touched
in the current transaction. This was a hack added to prevent core dumps
of the sort illustrated in bug #671,
http://archives.postgresql.org/pgsql-bugs/2002-05/msg00106.php
http://archives.postgresql.org/pgsql-bugs/2002-05/msg00113.php
There is a proper fix in 7.3, but it was deemed too risky to back-patch
into the 7.2 series.
I am surprised that you did not have horrible stability problems under
previous releases, if your application was in the habit of issuing
transactions like the above.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
