Skip site navigation (1) Skip section navigation (2)

Re: Table referenced by OID in a view?

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: Ron Johnson <ron(dot)l(dot)johnson(at)cox(dot)net>,"'pgsql-novice(at)postgresql(dot)org'" <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Table referenced by OID in a view?
Date: 2002-12-21 01:31:06
Message-ID: 200212201731.06132.josh@agliodbs.com (view raw or flat)
Thread:
Lists: pgsql-novice
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


In response to

Responses

pgsql-novice by date

Next:From: Tom LaneDate: 2002-12-21 01:33:42
Subject: Re: Table referenced by OID in a view?
Previous:From: Tom LaneDate: 2002-12-21 01:18:09
Subject: Re: Readline causing grief in build

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group