Re: Big problem - Mailing list pgsql-hackers

From Gaetano Mendola
Subject Re: Big problem
Date
Msg-id 40B240D7.2070205@bigfoot.com
Whole thread Raw
In response to Re: Big problem  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tom Lane wrote:

> Christopher Kings-Lynne <chriskl@familyhealth.com.au> writes:
> 
>>Hmmm - I agree it's difficult, but somehow I think it's something we 
>>should do.  Just imagine if some major user of postgres did it - they'd 
>>be screaming blue murder...
> 
> 
> Shrug.  Superusers can *always* shoot themselves in the foot in Postgres.
> Try "delete from pg_proc", for instance.  This sounds right up there
> with the notion of preventing a Unix superuser from doing "rm -rf /".

Why not simply add a flag "undeleteable" applicable only to super user?
In this way is enough in the initdb fase create the postgres user as
undeleateable.

I think this is resonable.


Regards
Gaetano Mendola




pgsql-hackers by date:

Previous
From: Gaetano Mendola
Date:
Subject: Re: Optimizer bug??
Next
From: "Ismail Kizir"
Date:
Subject: Re: Optimizer bug??