Re: created type not found in create table

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Open _ <opensheart(at)yahoo(dot)com>
Cc: "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: created type not found in create table
Date: 2020-12-24 17:25:24
Message-ID: 796495.1608830724@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Open _ <opensheart(at)yahoo(dot)com> 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Open _ 2020-12-24 17:44:32 Re: created type not found in create table
Previous Message Open _ 2020-12-24 17:20:29 created type not found in create table