Bug in RENAME TO?

From: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
To: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Bug in RENAME TO?
Date: 2004-06-12 10:51:02
Message-ID: 40CAE016.8070307@familyhealth.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message pgsql 2004-06-12 12:45:38 Re: I just got it: PostgreSQL Application Server -- a
Previous Message Christopher Kings-Lynne 2004-06-12 10:12:37 Re: [COMMITTERS] pgsql-server: Clean up generation of default