Re: Cannot create a type in pg_catalog

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Dave Page <dpage(at)postgresql(dot)org>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Cannot create a type in pg_catalog
Date: 2007-08-23 14:06:36
Message-ID: 993.1187877996@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Dave Page <dpage(at)postgresql(dot)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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Dave Page 2007-08-23 14:18:07 Re: Cannot create a type in pg_catalog
Previous Message Dave Page 2007-08-23 12:12:30 Re: BUG #3556: Installroutine hides destination folder