Re: Table referenced by OID in a view?

Ron,

> I don't know about other commercial RDBMSs, but some have this:
> DROP TABLE <foo> CASCADE
>
> Thus, any views, constraints, triggers, etc, that refer to <foo> get
> dropped automatically when the table is dropped.  This seems to be a
> step beyond what you mention for v7.4.  (Of course, all the deleteted
> objects are listed as they are deleted, so you can easily recreate
> them...

Hmmm.  Not sure this is planned; I personally would not want to *ever* use a
"DROP TABLE CASCADE".   Not up to me, though.

--
-Josh Berkus
 Aglio Database Solutions
 San Francisco