From: | Guillaume Lelarge <guillaume(at)lelarge(dot)info> |
---|---|
To: | "bdmytrak(at)eranet(dot)pl" <bdmytrak(at)eranet(dot)pl> |
Cc: | pgadmin-support(at)postgresql(dot)org |
Subject: | Re: ENUM type script in pgAdmin 1.14.0 |
Date: | 2011-09-26 07:02:29 |
Message-ID: | 1317020551.2173.1.camel@localhost.localdomain |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
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
From | Date | Subject | |
---|---|---|---|
Next Message | bdmytrak@eranet.pl | 2011-09-26 07:07:08 | Re: ENUM type script in pgAdmin 1.14.0 |
Previous Message | bdmytrak@eranet.pl | 2011-09-25 21:13:04 | ENUM type script in pgAdmin 1.14.0 |