Home > mailing lists

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

From	bdmytrak@eranet.pl
Subject	ENUM type script in pgAdmin 1.14.0
Date	September 25, 2011 22:13:14
Msg-id	2050840221.261316985184172.JavaMail.omnix03@wlas3 Whole thread Raw
Responses	Re: ENUM type script in pgAdmin 1.14.0 (Guillaume Lelarge <guillaume@lelarge.info>)
List	pgadmin-support

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

From: J Hobbs
Date: 24 September 2011, 20:00:10
Subject: pgadmin critical issue

From: Guillaume Lelarge
Date: 26 September 2011, 07:02:39
Subject: Re: ENUM type script in pgAdmin 1.14.0