Re: Building a database from a flat file

From: Markus Schaber <schabi(at)logix-tt(dot)com>
To: "Casey T(dot) Deccio" <ctdecci(at)sandia(dot)gov>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Building a database from a flat file
Date: 2005-03-03 20:21:49
Message-ID: 422771DD.9040409@logix-tt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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/

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Andrew - Supernews 2005-03-03 20:58:14 Re: definative way to place secs from epoc into timestamp
Previous Message Sean Davis 2005-03-03 19:30:27 Re: Building a database from a flat file