pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Sidar López Cruz <sidarlopez@hotmail.com>
To: pgsql-admin@postgresql.org
Subject: FW: truncate error
Date: Tue, 04 Oct 2005 10:01:42 -0600
Message-ID: <BAY23-F106139BBD22CF2F37A02C8CE830@phx.gbl> (raw)
In-Reply-To: <20051004152142.GC6925@surnet.cl>

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 <alvherre@alvh.no-ip.org>
>To: Sidar López Cruz <sidarlopez@hotmail.com>
>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/




view thread (4+ messages)  latest in thread

Message-ID: <BAY23-F106139BBD22CF2F37A02C8CE830@phx.gbl>
Permalink:  ../BAY23-F106139BBD22CF2F37A02C8CE830@phx.gbl/
Also on:    postgresql.org/message-id/BAY23-F106139BBD22CF2F37A02C8CE830@phx.gbl

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: sidarlopez@hotmail.com
  Subject: Re: FW: truncate error
  In-Reply-To: <BAY23-F106139BBD22CF2F37A02C8CE830@phx.gbl>
  References: <20051004152142.GC6925@surnet.cl> <BAY23-F106139BBD22CF2F37A02C8CE830@phx.gbl>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox