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