Commit1d1f425

committed

Add note that PREPARE TRANSACTION is for transaction managers, not

regular applications. Also add a comment pointing out that tab-complitionfor PREPARE TRANSACTION is missing on purpose.

1 parente7dcfd0 commit1d1f425Copy full SHA for 1d1f425

File tree

+16

-2

lines changed

+16

-2

lines changed

Lines changed: 10 additions & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -1,5 +1,5 @@`
`1`	`1`	`<!--`
`2`		`-$PostgreSQL: pgsql/doc/src/sgml/ref/prepare_transaction.sgml,v 1.9 2009/04/23 00:23:45 tgl Exp $`
	`2`	`+$PostgreSQL: pgsql/doc/src/sgml/ref/prepare_transaction.sgml,v 1.10 2010/01/25 18:23:10 heikki Exp $`
`3`	`3`	`PostgreSQL documentation`
`4`	`4`	`-->`
`5`	`5`
`@@ -82,6 +82,15 @@ PREPARE TRANSACTION <replaceable class="PARAMETER">transaction_id</replaceable>`
`82`	`82`	`<refsect1>`
`83`	`83`	`<title>Notes</title>`
`84`	`84`
	`85`	`+ <para>`
	`86`	`+ <command>PREPARE TRANSACTION</> is not intended for use in applications`
	`87`	`+ or interactive sessions. It's purpose is to allow an external`
	`88`	`+ transaction manager to perform atomic global transactions across multiple`
	`89`	`+ databases or other transactional resources. Unless you're writing a`
	`90`	`+ transaction manager, you probably shouldn't be using <command>PREPARE`
	`91`	`+ TRANSACTION</>.`
	`92`	`+ </para>`
	`93`	`+`
`85`	`94`	`<para>`
`86`	`95`	`This command must be used inside a transaction block. Use <xref`
`87`	`96`	`linkend="sql-begin" endterm="sql-begin-title"> to start one.`

Lines changed: 6 additions & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -3,7 +3,7 @@`
`3`	`3`	`*`
`4`	`4`	`* Copyright (c) 2000-2010, PostgreSQL Global Development Group`
`5`	`5`	`*`
`6`		`- * $PostgreSQL: pgsql/src/bin/psql/tab-complete.c,v 1.191 2010/01/22 16:40:19 rhaas Exp $`
	`6`	`+ * $PostgreSQL: pgsql/src/bin/psql/tab-complete.c,v 1.192 2010/01/25 18:23:09 heikki Exp $`
`7`	`7`	`*/`
`8`	`8`
`9`	`9`	`/*----------------------------------------------------------------------`
`@@ -1882,6 +1882,11 @@ psql_completion(char *text, int start, int end)`
`1882`	`1882`	`COMPLETE_WITH_LIST(list_PREPARE);`
`1883`	`1883`	`}`
`1884`	`1884`
	`1885`	`+/*`
	`1886`	`+ * PREPARE TRANSACTION is missing on purpose. It's intended for transaction`
	`1887`	`+ * managers, not for manual use in interactive sessions.`
	`1888`	`+ */`
	`1889`	`+`
`1885`	`1890`	`/* REASSIGN OWNED BY xxx TO yyy */`
`1886`	`1891`	`elseif (pg_strcasecmp(prev_wd,"REASSIGN")==0)`
`1887`	`1892`	`COMPLETE_WITH_CONST("OWNED");`

Comments

(0)