ENUM type script in pgAdmin 1.14.0

Поиск

Список

Период

Сортировка

От	bdmytrak@eranet.pl
Тема	ENUM type script in pgAdmin 1.14.0
Дата	25 сентября 2011 г. 19:13:14
Msg-id	2050840221.261316985184172.JavaMail.omnix03@wlas3 обсуждение исходный текст
Ответы	Re: ENUM type script in pgAdmin 1.14.0
Список	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

В списке pgadmin-support по дате отправления: