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: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice

> I don't know about other commercial RDBMSs, but some have this:
> 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


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-2017 The PostgreSQL Global Development Group