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

Hello

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

http://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=b152c6cd0de1827ba58756e24e18110cf902182a

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

postgres=# 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(dot)kratochvil(at)t-mobile(dot)cz>:

> The following bug has been logged on the website:
>
> Bug reference: 10294
> Logged by: Aleš Kratochvíl
> Email address: ales(dot)kratochvil(at)t-mobile(dot)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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-bugs
>