Re: Building a database from a flat file

Поиск
Список
Период
Сортировка
От Markus Schaber
Тема Re: Building a database from a flat file
Дата
Msg-id 422771DD.9040409@logix-tt.com
обсуждение исходный текст
Ответ на Re: Building a database from a flat file  ("Casey T. Deccio" <ctdecci@sandia.gov>)
Список 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 по дате отправления:

Предыдущее
От: Sean Davis
Дата:
Сообщение: Re: Building a database from a flat file
Следующее
От: Andrew - Supernews
Дата:
Сообщение: Re: definative way to place secs from epoc into timestamp