Bruce Momjian wrote: > 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.
Yeah, that's a good idea too. -- Heikki Linnakangas EnterpriseDB http://www.enterprisedb.com -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers