On Sun, 2011-09-25 at 23:13 +0200, bdmyt...@eranet.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@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support