Peter Eisentraut wrote: > > Alex Pilosov writes: > > > > I'm not so convinced on that idea. Assume you're dropping object foo. > > > You look at pg_depend and see that objects 145928, 264792, and 1893723 > > > depend on it. Great, what do you do now? > > I believe someone else previously suggested this: > > > > 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 ? regards, Hiroshi Inoue ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster