Re: Bug #796: Problem after upgrading to v. 723 - Mailing list pgsql-bugs

pgsql-bugs@postgresql.org 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