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

Reply via email to