Heikki Linnakangas wrote:
> Bruce Momjian wrote:
> > Heikki Linnakangas wrote:
> >> 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.
> >
> > I think we should add a C comment documenting that fact.
>
> Hmm, I thought we explained that in the manual, but I can't see it. I
> think we should add a note to the ref page of PREPARE TRANSACTION,
> something like:
>
> "PREPARE TRANSACTION is not intended for use in applications or in
> interactive sessions. It's purpose is to allow an external transaction
> manager to perform atomic global transactions across multiple databases
> or other transactional resources. Unless you're writing a transaction
> manager, you probably shouldn't be using PREPARE TRANSACTION"
I was thinking of adding something in the psql C source code to explain
why certain commands are not implemented for tab completion.
-- Bruce Momjian <bruce@momjian.us> http://momjian.us EnterpriseDB
http://enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +