X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id E071E53347
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Fri, 13 May 2005 15:50:50 -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 99519-04
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Fri, 13 May 2005 18:50:46 +0000 (GMT)
Received: from rs25s9.datacenter.cha.cantv.net
	(rs25s9.datacenter.cha.cantv.net [200.44.33.10])
	by svr1.postgresql.org (Postfix) with ESMTP id D396553238
	for <pgsql-sql@postgresql.org>; Fri, 13 May 2005 15:50:45 -0300 (ADT)
Received: from tgusta2 (dC85A71E0.dslam-21-1-18-10-2-02.fsl.dsl.cantv.net
	[200.90.113.224])
	by rs25s9.datacenter.cha.cantv.net (8.13.0/8.13.0/3.0) with SMTP id
	j4DInKpr012482; Fri, 13 May 2005 14:50:08 -0400
X-Matched-Lists: []
Message-ID: <01c301c557ec$9983b090$1400a8c0@tgusta2>
Reply-To: "Ing. Jhon Carrillo" <jdigital@cantv.net>
From: "Ing. Jhon Carrillo" <jdigital@cantv.net>
To: "Mark Fenbers" <Mark.Fenbers@noaa.gov>,
	<pgsql-sql@postgresql.org>
References: <4284F421.10809@noaa.gov>
Subject: Re: Replacing a table with constraints
Date: Fri, 13 May 2005 14:49:38 -0400
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_01C0_01C557CA.FD041280"
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
X-Virus-Scanned: ClamAV version 0.84, clamav-milter version 0.84e on
	rs25s9.datacenter.cha.cantv.net
X-Virus-Status: Clean
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.264 tagged_above=0 required=5 tests=AWL, HTML_50_60,
	HTML_MESSAGE
X-Spam-Level: 
X-Archive-Number: 200505/99
X-Sequence-Number: 21412

This is a multi-part message in MIME format.

------=_NextPart_000_01C0_01C557CA.FD041280
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Use          Drop table YOUR_TABLE cascade

Jhon Carrillo
Ingeniero en Computaci=F3n
Caracas - Venezuela



----- Original Message -----=20
  From: Mark Fenbers=20
  To: pgsql-sql@postgresql.org=20
  Sent: Friday, May 13, 2005 2:38 PM
  Subject: [SQL] Replacing a table with constraints


  I have a table called Counties which partially contains a lot bad =
data.  By" bad data", I mean some records are missing; some exist and =
shouldn't; and some records have fields with erroneous information.  =
However, the majority of the data in the table is accurate.  I have =
built/loaded a new table called newCounties with the same structure as =
Counties, but contains no bad data.  My was  to completely replace the =
contents of Counties with the contents of newCounties.  The problem is: =
several other tables have Foreign Key constraints placed on Counties.  =
Therefore, Pg will not let me 'DELETE FROM Counties;", nor will it let =
me "DROP TABLE Counties;" =20

  I'm perplexed.  Can someone suggest how I can best get data from =
Counties to look just like newCounties?

  Mark



-------------------------------------------------------------------------=
-----



  ---------------------------(end of =
broadcast)---------------------------
  TIP 8: explain analyze is your friend


------=_NextPart_000_01C0_01C557CA.FD041280
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type =
content=3Dtext/html;charset=3DISO-8859-1>
<META content=3D"MSHTML 6.00.2600.0" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY text=3D#333399 bgColor=3D#ffffff>
<DIV><FONT face=3DArial color=3D#000000=20
size=3D2>Use&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;Drop =
table=20
YOUR_TABLE <STRONG>cascade</STRONG></FONT></DIV>
<DIV><FONT face=3DArial color=3D#000000 size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT color=3D#000000>Jhon Carrillo<BR>Ingeniero en=20
Computaci=F3n<BR></FONT><FONT color=3D#000000>Caracas - =
Venezuela<BR></FONT></DIV>
<DIV><FONT face=3DArial color=3D#000000 size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial color=3D#000000 size=3D2></FONT>&nbsp;</DIV>
<DIV>----- Original Message ----- </DIV>
<BLOCKQUOTE=20
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
  <DIV=20
  style=3D"BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: =
black"><B>From:</B>=20
  <A title=3DMark.Fenbers@noaa.gov =
href=3D"mailto:Mark.Fenbers@noaa.gov">Mark=20
  Fenbers</A> </DIV>
  <DIV style=3D"FONT: 10pt arial"><B>To:</B> <A =
title=3Dpgsql-sql@postgresql.org=20
  href=3D"mailto:pgsql-sql@postgresql.org">pgsql-sql@postgresql.org</A> =
</DIV>
  <DIV style=3D"FONT: 10pt arial"><B>Sent:</B> Friday, May 13, 2005 2:38 =
PM</DIV>
  <DIV style=3D"FONT: 10pt arial"><B>Subject:</B> [SQL] Replacing a =
table with=20
  constraints</DIV>
  <DIV><BR></DIV>I have a table called Counties which partially contains =
a lot=20
  bad data.&nbsp; By" bad data", I mean some records are missing; some =
exist and=20
  shouldn't; and some records have fields with erroneous =
information.&nbsp;=20
  However, the majority of the data in the table is accurate.&nbsp; I =
have=20
  built/loaded a new table called newCounties with the same structure as =

  Counties, but contains no bad data.&nbsp; My was&nbsp; to completely =
replace=20
  the contents of Counties with the contents of newCounties.&nbsp; The =
problem=20
  is: several other tables have Foreign Key constraints placed on=20
  Counties.&nbsp; Therefore, Pg will not let me 'DELETE FROM Counties;", =
nor=20
  will it let me "DROP TABLE Counties;"&nbsp; <BR><BR>I'm =
perplexed.&nbsp; Can=20
  someone suggest how I can best get data from Counties to look just =
like=20
  newCounties?<BR><BR>Mark<BR>
  <P>
  <HR>

  <P></P><BR>---------------------------(end of=20
  broadcast)---------------------------<BR>TIP 8: explain analyze is =
your=20
  friend<BR></BLOCKQUOTE></BODY></HTML>

------=_NextPart_000_01C0_01C557CA.FD041280--