Re: ERROR: subtransaction logged without previous top-level txn record

From: Arseny Sher <a(dot)sher(at)postgrespro(dot)ru>
To: Dan Katz <dkatz(at)joor(dot)com>
Cc: Andres Freund <andres(at)anarazel(dot)de>, Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>, "Hsu\, John" <hsuchen(at)amazon(dot)com>, "pgsql-bugs\(at)lists(dot)postgresql(dot)org" <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: Re: ERROR: subtransaction logged without previous top-level txn record
Date: 2019-12-17 15:15:42
Message-ID: 87o8w7vv8h.fsf@ars-thinkpad
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-hackers


Dan Katz <dkatz(at)joor(dot)com> writes:

> Is the resolution of the issue in this thread being tracked elsewhere,
> either in a commit fest or other stream of work?

Ok, I've created a cf entry:
https://commitfest.postgresql.org/26/2383/

I believe it is the most important to commit at least

0002-Stop-demanding-that-top-xact-must-be-seen-before-sub.patch

from my mail above -- as we see, this issue creates problems in the
field. Moreover, the patch is trivial and hopefully I've shown that
ERROR triggers were spurious and there is no easy way to relax the
check.

--
Arseny Sher
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2019-12-17 16:31:34 Re: Planning time is high in Postgres 11.5 Compared with Postgres 10.11
Previous Message PG Bug reporting form 2019-12-17 14:56:55 BUG #16170: pgadmin 4 won't even start

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2019-12-17 16:01:03 Re: client auth docs seem to have devolved
Previous Message Dan Katz 2019-12-17 14:49:11 Re: ERROR: subtransaction logged without previous top-level txn record