Commit788e799

committed

psql: allow DROP INDEX CONCURRENTLY in AUTOCOMMIT off mode

Previously this threw an error.Patch by Feike Steenbergen

1 parentbf03889 commit788e799Copy full SHA for 788e799

File tree

+18

-0

lines changed

+18

-0

lines changed

Lines changed: 18 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -1643,6 +1643,24 @@ command_no_begin(const char *query)`
`1643`	`1643`	`return true;`
`1644`	`1644`	`if (wordlen==10&&pg_strncasecmp(query,"tablespace",10)==0)`
`1645`	`1645`	`return true;`
	`1646`	`+`
	`1647`	`+/* DROP INDEX CONCURRENTLY isn't allowed in xacts */`
	`1648`	`+if (wordlen==5&&pg_strncasecmp(query,"index",5)==0)`
	`1649`	`+{`
	`1650`	`+query+=wordlen;`
	`1651`	`+`
	`1652`	`+query=skip_white_space(query);`
	`1653`	`+`
	`1654`	`+wordlen=0;`
	`1655`	`+while (isalpha((unsignedchar)query[wordlen]))`
	`1656`	`+wordlen+=PQmblen(&query[wordlen],pset.encoding);`
	`1657`	`+`
	`1658`	`+if (wordlen==12&&pg_strncasecmp(query,"concurrently",12)==0)`
	`1659`	`+return true;`
	`1660`	`+`
	`1661`	`+return false;`
	`1662`	`+}`
	`1663`	`+`
`1646`	`1664`	`return false;`
`1647`	`1665`	`}`
`1648`	`1666`

Comments

(0)