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 <br...@momjian.us> http://momjian.us EnterpriseDB http://enterprisedb.com + If your life is a hard drive, Christ can be your backup. + -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
