True, but Counties has about 8 or 9 rules, view, or pk constraints
attached to it. I don't want to break all these unless I knew of a way
to save off the SQL for them beforehand so I can easily rebuild them...
Mark
Ing. Jhon Carrillo wrote:
Use Drop
table YOUR_TABLE cascade
Jhon Carrillo
Ingeniero en Computación
Caracas - Venezuela
----- Original Message -----
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;"
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
|
begin:vcard
fn:Mark Fenbers
n:Fenbers;Mark
org:DoC/NOAA/NWS/OHRFC
adr:;;1901 South SR 134;Wilmington;OH;45177-9708;USA
email;internet:[EMAIL PROTECTED]
title:Sr. HAS Meteorologist
tel;work:937-383-0430 x246
x-mozilla-html:TRUE
url:http://weather.gov/ohrfc
version:2.1
end:vcard
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
