Re: [PATCH] V3: Idle in transaction cancellation
From:
"Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To:
"Andres Freund" <andres(at)anarazel(dot)de>, <pgsql-hackers(at)postgresql(dot)org>
Subject:
Re: [PATCH] V3: Idle in transaction cancellation
Date:
2010-11-02 17:33:15
Message-ID:
4CD0050B0200002500037194@gw.wicourts.gov (view raw or flat )
Thread:
2010-10-17 17:58:43 from Andres Freund <andres(at)anarazel(dot)de>
2010-10-19 14:18:29 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2010-10-19 14:27:17 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-10-30 08:49:21 from Andres Freund <andres(at)anarazel(dot)de>
2010-11-02 17:33:15 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2010-11-02 21:36:19 from Andres Freund <andres(at)anarazel(dot)de>
2010-11-02 21:52:17 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2010-11-02 21:59:15 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2010-11-02 22:11:56 from Andres Freund <andres(at)anarazel(dot)de>
2010-11-02 22:52:40 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-11-29 22:38:48 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2010-11-29 23:42:57 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2010-12-01 23:48:53 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2010-12-02 14:57:18 from Andres Freund <andres(at)anarazel(dot)de>
2010-12-02 18:35:35 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2010-12-02 20:54:54 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2010-12-02 21:21:37 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2010-12-02 21:36:51 from Andres Freund <andres(at)anarazel(dot)de>
2010-12-16 12:32:46 from Greg Smith <greg(at)2ndquadrant(dot)com>
2010-12-16 13:49:45 from Andres Freund <andres(at)anarazel(dot)de>
2010-12-16 16:58:24 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-12-16 17:12:30 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-12-16 17:46:43 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-12-16 18:03:14 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-12-16 18:24:50 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-12-16 20:10:31 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-12-16 20:18:58 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-12-16 20:32:17 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-12-16 20:41:10 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-12-16 20:49:38 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-12-16 20:54:51 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-12-16 21:30:02 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2010-12-16 22:55:36 from Andres Freund <andres(at)anarazel(dot)de>
2010-12-23 22:04:43 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2011-01-03 14:38:56 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2011-01-03 14:47:31 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2011-01-03 15:03:58 from Andres Freund <andres(at)anarazel(dot)de>
2011-01-04 03:25:22 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2010-12-15 01:20:31 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-12-15 12:13:30 from Andres Freund <andres(at)anarazel(dot)de>
2010-12-15 12:33:30 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-12-15 12:47:08 from Andres Freund <andres(at)anarazel(dot)de>
2010-12-15 14:40:20 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-12-15 15:02:14 from Andres Freund <andres(at)anarazel(dot)de>
2010-12-15 19:12:45 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-12-16 14:12:38 from Andres Freund <andres(at)anarazel(dot)de>
Lists:
pgsql-hackers
Andres Freund <andres(at)anarazel(dot)de> wrote:
> * You wont see an error if the next command after the IDLE in
> transaction is a COMMIT/ROLLBACK. I don*t see any sensible way
> around that.
Well, on a ROLLBACK I'm not sure it's a problem. On a COMMIT,
couldn't you call a function to check for it in CommitTransaction
and PrepareTransaction?
-Kevin
In response to
Responses
pgsql-hackers by date
Next :From: Robert HaasDate: 2010-11-02 17:54:51Subject : Re: ALTER TYPE recursion to typed tablesPrevious :From : Michael MeskesDate : 2010-11-02 17:19:42Subject : Re: Comparison with "true" in source code
