Re: Building a database from a flat file - Mailing list pgsql-sql

From Markus Schaber
Subject Re: Building a database from a flat file
Date
Msg-id 422771DD.9040409@logix-tt.com
Whole thread Raw
In response to Re: Building a database from a flat file  ("Casey T. Deccio" <ctdecci@sandia.gov>)
List pgsql-sql
Hi, Casey,

Casey T. Deccio schrieb:

> Building everything in the separate "build" schema works great, but it
> is the DELETE (TRUNCATE won't work when foreign keys point to the table)

Just as an additional info: You could temporarily drop the foreing key
constraints, run TRUNCATE, and recreate the constraints.

Markus

-- 
Markus Schaber | Dipl. Informatiker | Software Development GIS

Fight against software patents in EU! http://ffii.org/
http://nosoftwarepatents.org/


pgsql-sql by date:

Previous
From: Sean Davis
Date:
Subject: Re: Building a database from a flat file
Next
From: Andrew - Supernews
Date:
Subject: Re: definative way to place secs from epoc into timestamp