Re: created type not found in create table

[Tom Lane <tgl@xxxxxxxxxxxxx>]

Open _ <opensheart@xxxxxxxxx> writes:
>    CREATE TYPE staffadmin.staff_roll
>        as ENUM ('Not yet defined', 'Everything', 'Sys Admin', 'Developer', 'DBA', 'Security', 'Art & Apperance', 'Support', 'Manager') ;
>    CREATE TYPE

> ...

>    psql:/tmp/psql_tmp.5133.sql:16: ERROR:  type "staffadmin.staff_role" does not exist
>    LINE 9:   role           staffadmin.staff_role   NOT null ,
>                             ^


Uh, you didn't spell it that way before.

			regards, tom lane