Cannot create a type in pg_catalog

From: Dave Page <dpage(at)postgresql(dot)org>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Cannot create a type in pg_catalog
Date: 2007-08-23 11:30:29
Message-ID: 46CD6FD5.60302@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Dave Page 2007-08-23 12:12:30 Re: BUG #3556: Installroutine hides destination folder
Previous Message Zdenek Kotala 2007-08-23 08:55:14 Re: BUG #3567: invalid page header in block XXXXof relation