Re: [HACKERS] pg_depend

[Bill Studenmund]

On Tue, 17 Jul 2001, Hiroshi Inoue wrote:

> Peter Eisentraut wrote:
> > 
> > Alex Pilosov writes:
> > 
> > > drop <type> object [RESTRICT | CASCADE]
> > >
> > > to make use of dependency info.
> > 
> > That was me.  The point, however, was, given object id 145928, how the
> > heck to you know what table this comes from?
> > 
> 
> Is it really determined that *DROP OBJECT* drops the objects
> which are dependent on it ?

If you used DROP OBJECT CASCADE, yes. That's what CASCADE is saying.

I think the idea is that you can say what happens - delete dependents, or
do something else.

Take care,

Bill


---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html