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.
This is my fist post, so please don't yell on me ;)
regards,
Bartek