> After upgrading from v. 721 to 723 some of regression tests failed.
> CREATE SEQUENCE s_ASeq;
> SELECT nextval('s_ASeq') ;
> DROP SEQUENCE s_ASeq ;
> /* some sql statement might be here */
> 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,
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
In response to
pgsql-bugs by date
|Next:||From: Tom Lane||Date: 2002-10-12 22:36:10|
|Subject: Re: Bug #795: null resulting from left join corrupts select |
|Previous:||From: pgsql-bugs||Date: 2002-10-12 14:23:50|
|Subject: Bug #796: Problem after upgrading to v. 723|