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.
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 |