Re: Bug in RENAME TO? - Mailing list pgsql-hackers

From Christopher Kings-Lynne
Subject Re: Bug in RENAME TO?
Date
Msg-id 40CBC4D6.3070605@familyhealth.com.au
Whole thread Raw
In response to Re: Bug in RENAME TO?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
> As an example of why superusers should have as few restrictions as
> possible, I refer you to the 7.4.2 release notes:
> http://www.postgresql.org/docs/7.4/static/release.html#RELEASE-7-4-2
> Without the ability for superusers to muck with the system catalogs,
> we'd have had no choice but to force initdb for 7.4.2 to fix those
> errors.

My point being that the 7.4 release stuff is done via the catupd flag, 
not via standard SQL commands.  Seems to me that you should be protected 
from shooting yourself in the foot so long as you work through the 
standard SQL commands...surely?

The other thing of course is that any renames or owner changes they make 
to system objects will not be propogated at pg_dump time.

Chris



pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Big feature status
Next
From: Christopher Kings-Lynne
Date:
Subject: Re: Bug in RENAME TO?