Bug in RENAME TO? - Mailing list pgsql-hackers

From Christopher Kings-Lynne
Subject Bug in RENAME TO?
Date
Msg-id 40CAE016.8070307@familyhealth.com.au
Whole thread Raw
Responses Re: Bug in RENAME TO?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
I notice you can use most of the RENAME TO commands in postgres to 
rename system objects.  Renaming a system table is disallowed:

test=# alter table pg_namespace rename to blah;
ERROR:  permission denied: "pg_namespace" is a system catalog

But mucking with any other system object is not:

test=# alter function abbrev(inet) rename to bad;
ALTER FUNCTION

Is there logic in that?

Also, what about when I implement ALTER OWNER for everything?  Should 
that be banned on system objects?

Chris



pgsql-hackers by date:

Previous
From: Christopher Kings-Lynne
Date:
Subject: Re: [COMMITTERS] pgsql-server: Clean up generation of default
Next
From: pgsql@mohawksoft.com
Date:
Subject: Re: I just got it: PostgreSQL Application Server -- a