How to reference a composite type in schemas not "public"?

Поиск

Список

Период

Сортировка

От	a
Тема	How to reference a composite type in schemas not "public"?
Дата	14 июня 2018 г. 06:34:00
Msg-id	tencent_4885304D0B7E99C9368F7703@qq.com обсуждение
Ответы	Re: How to reference a composite type in schemas not "public"? Re: How to reference a composite type in schemas not "public"?
Список	pgsql-general

Hi I have created some composite type:

create type "MjorTbl".mort as(

adjfac float8,

tablename text,

subtype text,

improv float8,

selfac slfc

);

The schema is different from public, while I would like to create table using the composite type, it reports a error:

create type "MjorTbl".decrmt as(

nodecrmt int4,

mortality "MjorTbl"."mort"

);

ERROR: type "MjorTbl.mort" does not exist

SQL state: 42704

create type "MjorTbl".decrmt as(

nodecrmt int4,

mortality mort

);

ERROR: type "mort" does not exist

SQL state: 42704

How can I reference the created composite type correctly??

Thanks

Shore

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