Re: ENUM type script in pgAdmin 1.14.0 - Mailing list pgadmin-support

From Guillaume Lelarge
Subject Re: ENUM type script in pgAdmin 1.14.0
Date
Msg-id 1317020551.2173.1.camel@localhost.localdomain
Whole thread Raw
In response to ENUM type script in pgAdmin 1.14.0  ("bdmytrak@eranet.pl" <bdmytrak@eranet.pl>)
List pgadmin-support
On Sun, 2011-09-25 at 23:13 +0200, bdmytrak@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
andevery 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



pgadmin-support by date:

Previous
From: "bdmytrak@eranet.pl"
Date:
Subject: ENUM type script in pgAdmin 1.14.0
Next
From: "bdmytrak@eranet.pl"
Date:
Subject: Re: ENUM type script in pgAdmin 1.14.0