Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id B0D139FB24B for ; Wed, 4 Oct 2006 08:40:26 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 35073-04 for ; Wed, 4 Oct 2006 11:40:17 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.173]) by postgresql.org (Postfix) with ESMTP id 53BA59FB2D1 for ; Wed, 4 Oct 2006 08:40:17 -0300 (ADT) Received: by ug-out-1314.google.com with SMTP id 30so37955ugc for ; Wed, 04 Oct 2006 04:40:15 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:mime-version:content-type; b=mgcKeKdGlzDeQPZPSof3Vn+487ATjUbaoAYlEmxzyIXZoDBVVomFToWjRnI9WrBltR8/Ex+xkxE7NxW6JvHt7vM9rqv6H/uua4tQWVGoxuX9Tz5wFwIKPOtWbQNgWr6Y5pBvdPEnc1x51m/hehPHd9YPbH6Fhd1/A4GdtlJ2R/k= Received: by 10.67.24.13 with SMTP id b13mr468928ugj; Wed, 04 Oct 2006 04:40:15 -0700 (PDT) Received: by 10.67.94.13 with HTTP; Wed, 4 Oct 2006 04:40:15 -0700 (PDT) Message-ID: <55c095e90610040440v431e15a3m34fa72ef19c239e8@mail.gmail.com> Date: Wed, 4 Oct 2006 08:40:15 -0300 From: "Ezequias Rodrigues da Rocha" To: "pgAdmin Support" , pgsql-sql@postgresql.org Subject: How to overwrite a table [only data]? MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_26246_4658164.1159962015549" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.696 tagged_above=0 required=5 tests=DNS_FROM_RFC_ABUSE, HTML_40_50, HTML_MESSAGE, SPF_PASS X-Spam-Level: X-Archive-Number: 200610/11 X-Sequence-Number: 5848 ------=_Part_26246_4658164.1159962015549 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Hi list, I would like to overwrite a table with problem with his original. But there are some points. I can't just delete and restore it becouse it has a foreign key and when I try to delete it ask for drop cascade. As I know the drop cascade delete in both tables the rows related. Is it correct ? Regards... --=20 =3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D= -=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D- Atenciosamente (Sincerely) Ezequias Rodrigues da Rocha =3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D= -=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D- A pior das democracias ainda =E9 melhor do que a melhor das ditaduras The worst of democracies is still better than the better of dictatorships http://ezequiasrocha.blogspot.com/ ------=_Part_26246_4658164.1159962015549 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Hi list,

I would like to overwrite a table with problem with his original. But there= are some points.

I can't just delete and restore it becouse it has a foreign key and when I = try to delete it ask for drop cascade.

As I know the drop cascade delete in both tables the rows related. Is it co= rrect ?


Regards...

--
=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D= -=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-= =3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-
      = ;            &n= bsp;            = ;   Atenciosamente (Sincerely)
    &n= bsp;            = ;       Ezequias Rodrigues da Rocha
=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-= =3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D= -
A pior das democracias ainda =E9 melhor do que a melhor das ditaduras<= br>The worst of democracies is still better than the better of dictatorship= s
http://ezequiasrocha.bl= ogspot.com/ ------=_Part_26246_4658164.1159962015549--