Thread: psql tab-completion for COMMIT/ROLLBACK PREPARED

psql tab-completion for COMMIT/ROLLBACK PREPARED

From
Heikki Linnakangas
Date:
On Fri, 1 Jul 2005, Bruce Momjian wrote:

> Heikki Linnakangas wrote:
>> On Fri, 1 Jul 2005, Oliver Jowett wrote:
>>
>>> PS: noticed in passing: psql's help doesn't seem to know about the 2PC
>>> command syntax yet.
>>
>> True.
>>
>> Should we add support for it? 2PC is not something you normally do
>> interactively...
>
> Yes, we should add psql support for it.

Ok, here's a patch.

There's no tab-completion for "PREPARE TRANSACTION 'xxx'" since that would
be ambigous with "PREPARE xxx AS xx".

- Heikki

Attachment

Re: psql tab-completion for COMMIT/ROLLBACK PREPARED

From
Heikki Linnakangas
Date:
Oh, just realized after Tom's reply that you were talking about help, not
tab-completion...

On Fri, 1 Jul 2005, Heikki Linnakangas wrote:

> On Fri, 1 Jul 2005, Bruce Momjian wrote:
>
>> Heikki Linnakangas wrote:
>>> On Fri, 1 Jul 2005, Oliver Jowett wrote:
>>>
>>>> PS: noticed in passing: psql's help doesn't seem to know about the 2PC
>>>> command syntax yet.
>>>
>>> True.
>>>
>>> Should we add support for it? 2PC is not something you normally do
>>> interactively...
>>
>> Yes, we should add psql support for it.
>
> Ok, here's a patch.
>
> There's no tab-completion for "PREPARE TRANSACTION 'xxx'" since that would be
> ambigous with "PREPARE xxx AS xx".
>
> - Heikki

- Heikki

Re: psql tab-completion for COMMIT/ROLLBACK PREPARED

From
Bruce Momjian
Date:
Patch applied.  Thanks.

---------------------------------------------------------------------------


Heikki Linnakangas wrote:
> On Fri, 1 Jul 2005, Bruce Momjian wrote:
>
> > Heikki Linnakangas wrote:
> >> On Fri, 1 Jul 2005, Oliver Jowett wrote:
> >>
> >>> PS: noticed in passing: psql's help doesn't seem to know about the 2PC
> >>> command syntax yet.
> >>
> >> True.
> >>
> >> Should we add support for it? 2PC is not something you normally do
> >> interactively...
> >
> > Yes, we should add psql support for it.
>
> Ok, here's a patch.
>
> There's no tab-completion for "PREPARE TRANSACTION 'xxx'" since that would
> be ambigous with "PREPARE xxx AS xx".
>
> - Heikki

Content-Description:

[ Attachment, skipping... ]

>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
>        subscribe-nomail command to majordomo@postgresql.org so that your
>        message can get through to the mailing list cleanly

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073