The CASCADE behaviour will allow it to be dropped -- no matter what
(to a point).
--
Rod Taylor
Your eyes are weary from staring at the CRT. You feel sleepy. Notice
how restful it is to watch the cursor blink. Close your eyes. The
opinions stated above are yours. You cannot imagine why you ever felt
otherwise.
----- Original Message -----
From: "Christopher Kings-Lynne" <chriskl@familyhealth.com.au>
To: "Rod Taylor" <rbt@zort.ca>; <pgsql-patches@postgresql.org>
Sent: Saturday, April 06, 2002 9:59 PM
Subject: Re: [PATCHES] Completed pg_depend support
> > Also, try to drop type int4 ;) Restricts by default (fresh
initdb).
> >
> > template1=# drop type int4;
> > ERROR: Drop Restricted as Table pg_inherits Depends on Type int4
> >
> > TODO.depend is the list of actions I needed to do (or did). More
or
> > gives a list of affected areas.
>
> Do superusers have more privileges than normal users? ie. Does it
say
> prevent normal users from doing hideous stuff like dropping int4,
but allows
> a superuser to do it if they really want to?
>
> Chris
>
>