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

From Dave Page
Subject Cannot create a type in pg_catalog
Date
Msg-id 46CD6FD5.60302@postgresql.org
Whole thread Raw
Responses Re: Cannot create a type in pg_catalog
List pgsql-bugs
Should this work, or at least give a more appropriate error message?

demo=# SELECT version();
                                         version

------------------------------------------------------------------------------------------
 PostgreSQL 8.2.4 on i686-pc-mingw32, compiled by GCC gcc.exe (GCC)
3.4.2 (mingw-special)
(1 row)

demo=# SELECT rolname, rolsuper, rolcatupdate FROM pg_authid;
 rolname  | rolsuper | rolcatupdate
----------+----------+--------------
 postgres | t        | t
(1 row)

demo=# CREATE TYPE pg_catalog.mytype AS (data text);
ERROR:  permission denied to create "pg_catalog.mytype"
DETAIL:  System catalog modifications are currently disallowed.

I can successfully create functions in pg_catalog, just not types or
relations.

Regards, Dave.

pgsql-bugs by date:

Previous
From: "Marko Kreen"
Date:
Subject: Re: BUG #3571: call to decrypt causes segfault
Next
From: Dave Page
Date:
Subject: Re: BUG #3556: Installroutine hides destination folder