Skip site navigation (1) Skip section navigation (2)

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: Alvaro Herrera <alvherre(at)commandprompt(dot)com>, pgsql-bugs(at)postgresql(dot)org
Subject: Re: Cannot create a type in pg_catalog
Date: 2007-08-23 15:22:54
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-bugs
Dave Page <dpage(at)postgresql(dot)org> writes:
> Tom Lane wrote:
>> The actual prohibition is on inserting a new pg_class row, which Dave's
>> command is trying to do because he's trying to create a composite type.

> If thats the case, then there's another inconsistency as I can insert a
> pg_class row manually without any problems:

Right, that's the end of it that's protected by rolcatupdate.  The
check that is firing on you is in heap_create(), which is invoked
for composite types.

The whole allow_system_table_mods mechanism dates from Berkeley days,
and I guess you could argue that we might not need it anymore given
the improvements since then in ACL enforcement.  I'm not in a big
hurry to rip it out though.  Not being allowed to TRUNCATE pg_class
seems like a Good Thing to me.

			regards, tom lane

In response to


pgsql-bugs by date

Next:From: Dave PageDate: 2007-08-23 15:36:06
Subject: Re: Cannot create a type in pg_catalog
Previous:From: Dave PageDate: 2007-08-23 14:57:43
Subject: Re: Cannot create a type in pg_catalog

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group