Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux