Re: [BUGS] BUG #7650: DROP TABLE IF EXISTS fails if schema does not exist

2013-06-28 Thread Bruce Momjian
On Sun, Nov 11, 2012 at 03:17:34PM +, j...@zer7.com wrote:
> The following bug has been logged on the website:
> 
> Bug reference:  7650
> Logged by:  James Bellinger
> Email address:  j...@zer7.com
> PostgreSQL version: 9.1.5
> Operating system:   Ubuntu Linux 12.04 Server
> Description:
> 
> Not sure this worked last time (I got some DMARC error), but here's a
> bug...
> 
> If a schema does not exist, DROP TABLE IF EXISTS schema.table will cause the
> transaction to fail (due to 'schema does not exist'). End result, DROP TABLE
> IF EXISTS is pretty much unusable with schemas. It needs to act the same as
> DROP TABLE IF EXISTS does for the default schema.

FYI, this will be fixed in Postgres 9.3.

-- 
  Bruce Momjian  http://momjian.us
  EnterpriseDB http://enterprisedb.com

  + It's impossible for everything to be true. +


-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs


[BUGS] BUG #7650: DROP TABLE IF EXISTS fails if schema does not exist

2012-11-11 Thread jfb
The following bug has been logged on the website:

Bug reference:  7650
Logged by:  James Bellinger
Email address:  j...@zer7.com
PostgreSQL version: 9.1.5
Operating system:   Ubuntu Linux 12.04 Server
Description:

Not sure this worked last time (I got some DMARC error), but here's a
bug...

If a schema does not exist, DROP TABLE IF EXISTS schema.table will cause the
transaction to fail (due to 'schema does not exist'). End result, DROP TABLE
IF EXISTS is pretty much unusable with schemas. It needs to act the same as
DROP TABLE IF EXISTS does for the default schema.

Have a good day

James



-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs