From: | Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com> |
---|---|
To: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: tab completion for prepared transactions? |
Date: | 2010-01-24 17:29:58 |
Message-ID: | 4B5C8396.6080406@enterprisedb.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Peter Eisentraut wrote:
> On lör, 2010-01-23 at 12:42 -0500, Tom Lane wrote:
>> Peter Eisentraut <peter_e(at)gmx(dot)net> writes:
>>> Was there a designed-in reason not to have psql tab completion for
>>> COMMIT/ROLLBACK PREPARED ...? It does complete the "PREPARED" but not
>>> the transaction identifiers. Maybe it's not a common use case, but
>>> these transaction identifiers sure can be nontrivial to type.
>> Hmm, what's the use scenario? I would think that painfully long
>> gxids would come from some XA manager software, which would be
>> responsible for committing or canceling them. Manual override
>> of that would usually be a bad idea.
Right, I vaguely recall that the idea of tab-completion for those
commands was rejected when 2PC was added because of that. A user sitting
at a psql terminal is not supposed to prepare a transaction. That's
application server's business.
> The scenario that I encountered is that you go around manually cleaning
> them up when the XA software fails for some reason.
Hmm, that's a good point though. Maybe it would make sense to add tab
completion for ROLLBACK/COMMIT PREPARED, but not for PREPARE TRANSACTION?
--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2010-01-24 17:30:26 | Re: further explain changes |
Previous Message | Magnus Hagander | 2010-01-24 17:25:38 | Re: Resetting a single statistics counter |