Re: Cannot create a type in pg_catalog - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Cannot create a type in pg_catalog
Date
Msg-id 993.1187877996@sss.pgh.pa.us
Whole thread Raw
In response to Cannot create a type in pg_catalog  (Dave Page <dpage@postgresql.org>)
Responses Re: Cannot create a type in pg_catalog
List pgsql-bugs
Dave Page <dpage@postgresql.org> writes:
> Should this work, or at least give a more appropriate error message?
> demo=# CREATE TYPE pg_catalog.mytype AS (data text);
> ERROR:  permission denied to create "pg_catalog.mytype"
> DETAIL:  System catalog modifications are currently disallowed.

Seems like a perfectly appropriate error message to me: it's disallowed.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Dave Page
Date:
Subject: Re: BUG #3556: Installroutine hides destination folder
Next
From: Dave Page
Date:
Subject: Re: Cannot create a type in pg_catalog