Postgres Pro
Downloads
Home   >   mailing lists

Thread: BUG #10294: DROP DOMAIN IF EXISTS does not work as expected if schema does not exist also

BUG #10294: DROP DOMAIN IF EXISTS does not work as expected if schema does not exist also

From
ales.kratochvil@t-mobile.cz
Date:
The following bug has been logged on the website:

Bug reference:      10294
Logged by:          Aleš Kratochvíl
Email address:      ales.kratochvil@t-mobile.cz
PostgreSQL version: 9.3.4
Operating system:   Windows XP 32-bit
Description:

----------------------------------------------
-- Drop LO Domain
----------------------------------------------
DROP DOMAIN IF EXISTS "EA_Repository".LO;

ERROR:  schema "EA_Repository" does not exist
********** Chyba **********

ERROR: schema "EA_Repository" does not exist
Stav SQL: 3F000

Re: BUG #10294: DROP DOMAIN IF EXISTS does not work as expected if schema does not exist also

From
Pavel Stehule
Date:
Hello

In this moment, this behave is expected. But DROP IF EXISTS statement was
refactored in 9.4

http://git.postgresql.org/gitweb/?p=3Dpostgresql.git;a=3Dcommitdiff;h=3Db15=
2c6cd0de1827ba58756e24e18110cf902182a

postgres=3D# DROP DOMAIN IF EXISTS "EA_Repository".LO;
NOTICE:  schema "EA_Repository" does not exist, skipping
DROP DOMAIN
postgres=3D#

postgres=3D# select version();

version
---------------------------------------------------------------------------=
--------------------------------------
 PostgreSQL 9.4beta1 on x86_64-unknown-linux-gnu, compiled by gcc (GCC)
4.8.2 20131212 (Red Hat 4.8.2-7), 64-bit
(1 row)

Regards

Pavel Stehule


2014-05-12 13:48 GMT+02:00 <ales.kratochvil@t-mobile.cz>:

> The following bug has been logged on the website:
>
> Bug reference:      10294
> Logged by:          Ale=C5=A1 Kratochv=C3=ADl
> Email address:      ales.kratochvil@t-mobile.cz
> PostgreSQL version: 9.3.4
> Operating system:   Windows XP 32-bit
> Description:
>
> ----------------------------------------------
> -- Drop LO Domain
> ----------------------------------------------
> DROP DOMAIN IF EXISTS "EA_Repository".LO;
>
> ERROR:  schema "EA_Repository" does not exist
> ********** Chyba **********
>
> ERROR: schema "EA_Repository" does not exist
> Stav SQL: 3F000
>
>
> --
> Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-bugs
>