Re: autonomous transactions

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Robert Haas <robertmhaas(at)gmail(dot)com>
Cc: Dimitri Fontaine <dfontaine(at)hi-media(dot)com>, Alvaro Herrera <alvherre(at)commandprompt(dot)com>, Darren Duncan <darren(at)darrenduncan(dot)net>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>, "Colin 't Hart" <colinthart(at)gmail(dot)com>
Subject: Re: autonomous transactions
Date: 2010-09-16 14:42:05
Message-ID: 12288.1284648125@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Robert Haas <robertmhaas(at)gmail(dot)com> writes:
> I plan to reserve judgment on the best way of managing the relevant
> state until such time as someone has gone to the trouble of
> identifying what state that is.

The really fundamental problem here is that you never will be able to
identify all such state. Even assuming that you successfully completed
the herculean task of fixing the core backend, what of add-on code?

(This is also why I'm quite unimpressed with the idea of trying to
get backends to switch to a different database after startup.)

regards, tom lane

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Alvaro Herrera 2010-09-16 15:12:51 Re: bad variable subst after "AS"
Previous Message Robert Haas 2010-09-16 14:26:08 Re: bg worker: patch 1 of 6 - permanent process