Open _ <[email protected]> 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
