Return-Path: Delivered-To: apmail-db-torque-dev-archive@www.apache.org Received: (qmail 32102 invoked from network); 2 Apr 2005 07:38:27 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 2 Apr 2005 07:38:27 -0000 Received: (qmail 56441 invoked by uid 500); 2 Apr 2005 07:38:26 -0000 Delivered-To: apmail-db-torque-dev-archive@db.apache.org Received: (qmail 56426 invoked by uid 500); 2 Apr 2005 07:38:26 -0000 Mailing-List: contact torque-dev-help@db.apache.org; run by ezmlm Precedence: bulk List-Unsubscribe: List-Subscribe: List-Help: List-Post: List-Id: "Apache Torque Developers List" Reply-To: "Apache Torque Developers List" Delivered-To: mailing list torque-dev@db.apache.org Received: (qmail 56413 invoked by uid 99); 2 Apr 2005 07:38:26 -0000 X-ASF-Spam-Status: No, hits=-10.0 required=10.0 tests=ALL_TRUSTED X-Spam-Check-By: apache.org Received: from minotaur.apache.org (HELO minotaur.apache.org) (209.237.227.194) by apache.org (qpsmtpd/0.28) with SMTP; Fri, 01 Apr 2005 23:38:26 -0800 Received: (qmail 32094 invoked by uid 1977); 2 Apr 2005 07:38:25 -0000 Received: from localhost (sendmail-bs@127.0.0.1) by localhost with SMTP; 2 Apr 2005 07:38:25 -0000 Date: Fri, 1 Apr 2005 23:38:25 -0800 (PST) From: Thomas Fischer To: torque-dev@db.apache.org Subject: postgresql DROP TABLE CASCADE Message-ID: <20050401232341.T21686@minotaur.apache.org> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed X-Spam-Rating: localhost 1.6.2 0/1000/N X-Virus-Checked: Checked X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N Hi, since Postgresql 7.3 (released in november 2002), postgresql supports the "cascade" attribute in DROP TABLE. This gets around the problem that tables which depend on other tables tend not to be dropped because of the wrong dropping order. I would like to add the "cascade" to the generated "drop table..." commands in the sql scrips. Any comments, objections ? Thomas --------------------------------------------------------------------- To unsubscribe, e-mail: torque-dev-unsubscribe@db.apache.org For additional commands, e-mail: torque-dev-help@db.apache.org