Postgres Pro
Downloads
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
Msg-id 2050840221.261316985184172.JavaMail.omnix03@wlas3
Whole thread Raw
Responses Re: ENUM type script in pgAdmin 1.14.0
List pgadmin-support
Tree view
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 

pgadmin-support by date:

Previous
From: J Hobbs
Date:
Subject: pgadmin critical issue
Next
From: Guillaume Lelarge
Date:
Subject: Re: ENUM type script in pgAdmin 1.14.0