Re: Replacing a table with constraints

Are the constraints deferrable?

If they are, then you can replace the data with a single transaction.

If not, then you'll have to look at disabling triggers for the update.

On Fri, 2005-05-13 at 14:55, Mark Fenbers wrote:
> 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 -----
> > From: Mark Fenbers
> > To: pgsql-sql(at)postgresql(dot)org
> > 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
>
>
> ______________________________________________________________________
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org