<font color="#000000" face="verdana" size="4"><font size="2">Thanks for reply,<br /><br />Maybe my post was not clear,
butthis bug occures only for public schema. <br />Please try create enum in "public" not in "a b"<br /><br
/>Regards,<br/>Bartek<br /></font><br /><font color="black" face="tahoma" id="f74hd9661xnmbjd7" size="4"
style="font-size:12px;color:black"><br/>Pozdrawiam, <br />Bartek<br /></font><br /><font color="black" face="tahoma"
id="f74hd9661xnmbjd7"size="4" style="COLOR: black; FONT-SIZE: 12px">--- Oryginalna wiadomość ---<br /><br />Od:
GuillaumeLelarge [mailto: guillaume@lelarge.info]<br />Wysłane: Monday, September 26, 2011 09:02 AM<br />Do:
bdmytrak@eranet.pl<br />Kopia: pgadmin-support@postgresql.org <br />Temat: Re: [pgadmin-support] ENUM type script in
pgAdmin1.14.0<br />On Sun, 2011-09-25 at 23:13 +0200, bdmytrak@eranet.pl wrote:<br />> Hi All,<br />> I think
thereis a bug in "CREATE" script for ENUM types created in public schema.<br />> When You execute command:<br />>
CREATETYPE public."MyEnum" AS ENUM<br />> ('first','second', 'middle', 'last');<br />> and You use "Create
Script"functionality in pgAdmin, the script looks like this:<br />> -- Type: " MyEnum "<br />> -- DROP TYPE "
MyEnum";<br />> CREATE TYPE " MyEnum " AS ENUM<br />> (' first ',<br />> ' second ',<br />> ' middle ',<br
/>>' last ' );<br />> ALTER TYPE " MyEnum "<br />> OWNER TO postgres;<br />> It seems there is no schema
qualifiedname. It appears regardles search_patch setting. I've tried in different schema and every thing was OK.<br
/><br/>It works for me. I get this:<br /><br />CREATE TYPE "a b"."a strange datatype" AS ENUM<br />('a',<br />'b',<br
/>'c',<br/>'d');<br /><br />if the schema "a b" is not in my search_path (at connection time).<br /><br />> This is
myfist post, so please don't yell on me ;)<br /><br />We don't yell at people (at lest, most of the time :) ).<br /><br
/><br/>-- <br />Guillaume<br />http://blog.guillaume.lelarge.info<br />http://www.dalibo.com<br /><br /><br />-- <br
/>Sentvia pgadmin-support mailing list (pgadmin-support@postgresql.org)<br />To make changes to your subscription:<br
/>http://www.postgresql.org/mailpref/pgadmin-support<br/></font></font>