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 B4B25DA01F for ; Tue, 4 Oct 2005 13:01:47 -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 57487-03 for ; Tue, 4 Oct 2005 16:01:44 +0000 (GMT) Received: from hotmail.com (bay23-f10.bay23.hotmail.com [64.4.22.60]) by svr1.postgresql.org (Postfix) with ESMTP id 70334D9B21 for ; Tue, 4 Oct 2005 13:01:43 -0300 (ADT) Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Tue, 4 Oct 2005 09:01:43 -0700 Message-ID: Received: from 196.40.18.42 by by23fd.bay23.hotmail.msn.com with HTTP; Tue, 04 Oct 2005 16:01:42 GMT X-Originating-IP: [196.40.18.42] X-Originating-Email: [sidarlopez@hotmail.com] X-Sender: sidarlopez@hotmail.com In-Reply-To: <20051004152142.GC6925@surnet.cl> From: =?iso-8859-1?B?U2lkYXIgTPNwZXogQ3J1eg==?= To: pgsql-admin@postgresql.org Subject: FW: truncate error Date: Tue, 04 Oct 2005 10:01:42 -0600 Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1; format=flowed X-OriginalArrivalTime: 04 Oct 2005 16:01:43.0101 (UTC) FILETIME=[E9DFF6D0:01C5C8FC] X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.358 required=5 tests=[AWL=-0.392, DNS_FROM_RFC_ABUSE=0.374, DNS_FROM_RFC_POST=1.376, MSGID_FROM_MTA_HEADER=0] X-Spam-Level: * X-Archive-Number: 200510/60 X-Sequence-Number: 19132 Yo primero hice truncate a la tabla derivada y luego a la tabla maestra y PostgreSQL no me lo permitia, entonces hice DELETE sobre la tabla maestro y si pudo borrar los registros, aun no se porque pasa eso. >From: Alvaro Herrera >To: Sidar López Cruz >CC: pgsql-admin@postgresql.org >Subject: Re: [ADMIN] truncate error >Date: Tue, 4 Oct 2005 11:21:42 -0400 > >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" > >---------------------------(end of broadcast)--------------------------- >TIP 1: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that your > message can get through to the mailing list cleanly _________________________________________________________________ MSN Amor: busca tu ½ naranja http://latam.msn.com/amor/