Horton
Menu

Re: PGXS: REGRESS_OPTS=--load-language=plpgsql

Tom Lane <tgl@sss.pgh.pa.us>

View thread
From: Tom Lane <tgl@sss.pgh.pa.us>
To: "David E. Wheeler" <david@kineticode.com>
Cc: Robert Haas <robertmhaas@gmail.com>, Bruce Momjian <bruce@momjian.us>, Dimitri Fontaine <dfontaine@hi-media.com>, Takahiro Itagaki <itagaki.takahiro@oss.ntt.co.jp>, David Fetter <david@fetter.org>, Euler Taveira de Oliveira <euler@timbira.com>, PG Hackers <pgsql-hackers@postgresql.org>
Date: 2010-02-20T23:57:02Z
Lists: pgsql-hackers 
"David E. Wheeler" <david@kineticode.com> writes:
> Just throwing this out there: would a syntax such as CREATE OF NOT  
> EXISTS, a complement to DROP IF EXISTS, avoid the permissions issue?  

No, it'd just move it to a different place: now you risk breaking
the restored state rather than pre-existing state.

> And if so, would that be a syntax we'd want to accept in general?  
> Could the be a CREATE IF NOT EXISTS TABLE?

*Please* go read some of the linked older discussions before you propose
that.  I don't want to rehash it yet again.

			regards, tom lane