X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id D02F852A4F for ; Mon, 7 Mar 2005 21:39:01 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 15231-04 for ; Mon, 7 Mar 2005 21:38:53 +0000 (GMT) Received: from rproxy.gmail.com (rproxy.gmail.com [64.233.170.196]) by svr1.postgresql.org (Postfix) with ESMTP id C5C0E56405 for ; Mon, 7 Mar 2005 21:38:52 +0000 (GMT) Received: by rproxy.gmail.com with SMTP id a41so1174465rng for ; Mon, 07 Mar 2005 13:38:54 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:mime-version:content-type:content-transfer-encoding; b=lLCOHIpzpao+qmll1rXoLIqsFvqgRuZ/7y/cgThMYh+QC8hbXBTl/PvA7/hO4x+iYn35ntkBT6zBI9My0sUBC5STuBD1qq95Kc+nuyt0pMUFmrKUsHNMfkGIIf4fb1hJzUEbcoRZOWtdfbs4x/TO9Ryg7HD4s+m7sYsVe794+V0= Received: by 10.38.24.32 with SMTP id 32mr18259rnx; Mon, 07 Mar 2005 13:38:54 -0800 (PST) Received: by 10.38.149.34 with HTTP; Mon, 7 Mar 2005 13:38:53 -0800 (PST) Message-ID: <2bffcc3305030713384c81d59b@mail.gmail.com> Date: Mon, 7 Mar 2005 16:38:53 -0500 From: Henry Ortega Reply-To: Henry Ortega To: pgsql-sql@postgresql.org Subject: drop view even with dependencies? Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Archive-Number: 200503/113 X-Sequence-Number: 20592 Is there a way to drop a VIEW in postgres without the need to drop all the dependencies? VIEW 3 | VIEW 2 | VIEW 1 In my case, VIEW 3 depends on VIEW 2, and VIEW 2 depends on VIEW 1. Is there a way to drop VIEW 3 without dropping VIEW 1 and 2? I tried CREATE OR REPLACE VIEW but replace will only work if they have the same number of fields. Also with tables, can I drop a table even if there are multiple views that depend on it? It's such a pain in the neck to have to drop all the dependencies and recreate them all over again. Any help would greatly appreciated. I am using Postgres 7.3.2