Re: Assertion failure with a subtransaction and cursor

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Assertion failure with a subtransaction and cursor
Дата
Msg-id 23080.1259791190@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Assertion failure with a subtransaction and cursor  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
Ответы Re: Assertion failure with a subtransaction and cursor  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
Список pgsql-bugs
Heikki Linnakangas <heikki.linnakangas@enterprisedb.com> writes:
> The logical next step would be to get rid of the interXact concept
> altogether and always associate temporary files with the current
> resource owner; the caller should switch to a sufficiently long-lived
> one before calling.

That would mean having a session-lifespan resource owner, which doesn't
seem amazingly useful to me: we have no other resource types for which
that would be even a little bit sane.  I'm inclined to leave the temp
file API as nearly as possible as-is.  Having it attach only xact-local
files to the CurrentResourceOwner sounds fine to me.

One thought here is that my inclination would be to keep
CleanupTemporaryFiles in place and have it just look for temp files that
didn't get closed, as a debugging aid.  This is comparable to the
behavior of other modules that are mostly driven by resource managers.
We didn't take out the end-of-xact checks when we added resource manager
support elsewhere, and I'm not inclined to do that here.  I agree we
don't need an EOSubXact-time crosscheck, though.

Other than that quibble it looks sane from here.

            regards, tom lane

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Heikki Linnakangas
Дата:
Сообщение: Re: Assertion failure with a subtransaction and cursor
Следующее
От: "Michal Pasternak"
Дата:
Сообщение: BUG #5227: please add a divide operator for intervals