X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 1E38EDA036 for ; Tue, 4 Oct 2005 12:21:45 -0300 (ADT) 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 50605-01 for ; Tue, 4 Oct 2005 15:21:43 +0000 (GMT) Received: from mx1.surnet.cl (mx1.surnet.cl [216.155.73.180]) by svr1.postgresql.org (Postfix) with ESMTP id E8F23DA01D for ; Tue, 4 Oct 2005 12:21:42 -0300 (ADT) Received: from unknown (HELO cluster.surnet.cl) ([216.155.73.165]) by mx1.surnet.cl with ESMTP; 04 Oct 2005 11:22:23 -0400 Received: from alvh.no-ip.org (200.85.217.253) by cluster.surnet.cl (7.0.043) (authenticated as alvherre@surnet.cl) id 433A601F001B1219; Tue, 4 Oct 2005 11:21:41 -0400 Received: by alvh.no-ip.org (Postfix, from userid 1000) id 43B28C3A1DD; Tue, 4 Oct 2005 11:21:42 -0400 (CLT) Date: Tue, 4 Oct 2005 11:21:42 -0400 From: Alvaro Herrera To: Sidar =?iso-8859-1?Q?L=F3pez?= Cruz Cc: pgsql-admin@postgresql.org Subject: Re: truncate error Message-ID: <20051004152142.GC6925@surnet.cl> Mail-Followup-To: Sidar =?iso-8859-1?Q?L=F3pez?= Cruz , pgsql-admin@postgresql.org References: Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: User-Agent: Mutt/1.5.10i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.959 required=5 tests=[AWL=-0.817, DNS_FROM_RFC_ABUSE=0.374, DNS_FROM_RFC_POST=1.376, RCVD_IN_NJABL_PROXY=1.026] X-Spam-Level: * X-Archive-Number: 200510/56 X-Sequence-Number: 19128 On Tue, Oct 04, 2005 at 08:40:31AM -0600, Sidar López Cruz wrote: > PostgreSQL 8.1 beta 2 raise error on truncating tables with foreign keys, > try this to see !!! Hum, what were you trying to show us? Truncating tables with foreign keys is supposed to work as long as you truncate the referenced table at the same time. -- Alvaro Herrera Valdivia, Chile ICBM: S 39º 49' 17.7", W 73º 14' 26.8" "La felicidad no es mañana. La felicidad es ahora"