Re: ENUM type script in pgAdmin 1.14.0

Thanks for reply,
Maybe my post was not clear, but this bug occures only for public schema.
Please try create enum in "public" not in "a b"
Regards,
Bartek

Pozdrawiam,
Bartek

--- Oryginalna wiadomo?? ---
Od: Guillaume Lelarge [mailto: guillaume(at)lelarge(dot)info]
Wys?ane: Monday, September 26, 2011 09:02 AM
Do: bdmytrak(at)eranet(dot)pl
Kopia: pgadmin-support(at)postgresql(dot)org
Temat: Re: [pgadmin-support] ENUM type script in pgAdmin 1.14.0
On Sun, 2011-09-25 at 23:13 +0200, bdmytrak(at)eranet(dot)pl wrote:
> Hi All,
> I think there is a bug in "CREATE" script for ENUM types created in public schema.
> When You execute command:
> CREATE TYPE public."MyEnum" AS ENUM
> ('first','second', 'middle', 'last');
> and You use "Create Script" functionality in pgAdmin, the script looks like this:
> -- Type: " MyEnum "
> -- DROP TYPE " MyEnum ";
> CREATE TYPE " MyEnum " AS ENUM
> (' first ',
> ' second ',
> ' middle ',
> ' last ' );
> ALTER TYPE " MyEnum "
> OWNER TO postgres;
> It seems there is no schema qualified name. It appears regardles search_patch setting. I've tried in different schema and every thing was OK.
It works for me. I get this:
CREATE TYPE "a b"."a strange datatype" AS ENUM
('a',
'b',
'c',
'd');
if the schema "a b" is not in my search_path (at connection time).
> This is my fist post, so please don't yell on me ;)
We don't yell at people (at lest, most of the time :) ).
--
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com
--
Sent via pgadmin-support mailing list (pgadmin-support(at)postgresql(dot)org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support