Hello.
You wrote:
TL Pavel Golub pa...@microolap.com writes:
Is there any possibility that Postgres will have named transaction
ever, like Firebird?
TL What in heck is a named transaction, and why should we care?
TL regards, tom lane
Sorry guys, my bad. The thing is
Pavel Golub pa...@microolap.com writes:
[ proposal involving ]
SWITCH TRANSACTION first; -- switch context
So, what do you think guys?
No chance :-(. The amount of work that would be required is *vastly*
out of proportion to any possible benefit. Use multiple connections.
On 06/18/2009 02:42 AM, Pavel Golub wrote:
Now to implement customer's desire in PostgreSQL there are two ways:
1. Each script must be executed in the separate connection context
2. Each script must be executed inside critical section, in other
words current scipt must block others until
Hello, pgsql-hackers.
Is there any possibility that Postgres will have named transaction
ever, like Firebird?
Now for each transaction client should open separate connection. But
CONNECTION LIMIT option for database make this a little bit harder
--
With best wishes,
Pavel
Pavel Golub pa...@microolap.com writes:
Is there any possibility that Postgres will have named transaction
ever, like Firebird?
What in heck is a named transaction, and why should we care?
regards, tom lane
--
Sent via pgsql-hackers mailing list
On Jun 17, 2009, at 8:08 AM, Tom Lane wrote:
Pavel Golub pa...@microolap.com writes:
Is there any possibility that Postgres will have named transaction
ever, like Firebird?
What in heck is a named transaction, and why should we care?
That Tom Lane, so warm and cuddly!
David
--
Sent via
I'm curious what they ate too
--
Greg
On 17 Jun 2009, at 17:37, David E. Wheeler da...@kineticode.com
wrote:
On Jun 17, 2009, at 8:08 AM, Tom Lane wrote:
Pavel Golub pa...@microolap.com writes:
Is there any possibility that Postgres will have named transaction
ever, like Firebird?
Greg Stark greg.st...@enterprisedb.com wrote:
On Jun 17, 2009, at 8:08 AM, Tom Lane wrote:
Pavel Golub pa...@microolap.com writes:
Is there any possibility that Postgres will have named
transaction ever, like Firebird?
What in heck is a named transaction, and why should we care?
I'm
On Wed, Jun 17, 2009 at 12:41 PM, Greg Starkgreg.st...@enterprisedb.com wrote:
On 17 Jun 2009, at 17:37, David E. Wheeler da...@kineticode.com wrote:
On Jun 17, 2009, at 8:08 AM, Tom Lane wrote:
Pavel Golub pa...@microolap.com writes:
Is there any possibility that Postgres will have named
Tom Lane wrote:
Pavel Golub pa...@microolap.com writes:
Is there any possibility that Postgres will have named transaction
ever, like Firebird?
What in heck is a named transaction, and why should we care?
Isn't this just another name for a
Andrew Dunstan wrote:
Tom Lane wrote:
What in heck is a named transaction, and why should we care?
Isn't this just another name for a subtransaction or inner transaction
that can be separately committed?
AFAIK that's an autonomous transaction, at least to some other RDBMSs.
--
Alvaro
Alvaro Herrera wrote:
Andrew Dunstan wrote:
Tom Lane wrote:
What in heck is a named transaction, and why should we care?
Isn't this just another name for a subtransaction or inner transaction
that can be separately committed?
AFAIK that's an autonomous transaction,
Andrew Dunstan and...@dunslane.net writes:
Alvaro Herrera wrote:
AFAIK that's an autonomous transaction, at least to some other RDBMSs.
Right, but since I had to ask what that was recently I though I'd use a
bit more description :-)
Yes, but some other followups suggest that maybe a named
On Wed, Jun 17, 2009 at 6:40 PM, Alvaro
Herreraalvhe...@commandprompt.com wrote:
Andrew Dunstan wrote:
Tom Lane wrote:
What in heck is a named transaction, and why should we care?
Isn't this just another name for a subtransaction or inner transaction
that can be separately committed?
On Wed, Jun 17, 2009 at 3:04 PM, Greg Starkst...@enterprisedb.com wrote:
On Wed, Jun 17, 2009 at 6:40 PM, Alvaro
Herreraalvhe...@commandprompt.com wrote:
Andrew Dunstan wrote:
Tom Lane wrote:
What in heck is a named transaction, and why should we care?
Isn't this just another name for a
Greg Stark wrote:
On Wed, Jun 17, 2009 at 6:40 PM, Alvaro
Herreraalvhe...@commandprompt.com wrote:
AFAIK that's an autonomous transaction, at least to some other RDBMSs.
I have no idea what they are in Firebird but the name conjured up a
different (interesting) idea for me. I had the
Tom Lane t...@sss.pgh.pa.us wrote:
Yes, but some other followups suggest that maybe a named
transaction does something else entirely. Thus my request for a
definition of what the OP is actually asking for.
Well, a quick google search suggests that all three guesses here were
off base.
On Wed, 2009-06-17 at 14:38 -0500, Kevin Grittner wrote:
Tom Lane t...@sss.pgh.pa.us wrote:
Yes, but some other followups suggest that maybe a named
transaction does something else entirely. Thus my request for a
definition of what the OP is actually asking for.
Well, a quick
Tom Lane wrote:
Andrew Dunstan and...@dunslane.net writes:
Alvaro Herrera wrote:
AFAIK that's an autonomous transaction, at least to some other RDBMSs.
Right, but since I had to ask what that was recently I though I'd use a
bit more description :-)
Yes, but some
Kevin Grittner wrote:
Tom Lane t...@sss.pgh.pa.us wrote:
Yes, but some other followups suggest that maybe a named
transaction does something else entirely. Thus my request for a
definition of what the OP is actually asking for.
Well, a quick google search suggests that all three
On Wed, Jun 17, 2009 at 8:09 PM, Robert Haasrobertmh...@gmail.com wrote:
I have no idea what they are in Firebird but the name conjured up a
different (interesting) idea for me. I had the image of naming a
transaction and then being able to have other sessions join that same
transaction.
Andrew Dunstan and...@dunslane.net writes:
According to the (hard to find) Firebird docs (or rather, the old
Interbase docs, which is all they have):
A single application can start simultaneous transactions. InterBase
extends transaction
management and data manipulation
22 matches
Mail list logo