| From: | Vivek Khera <khera(at)kcilink(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: disabling constraints |
| Date: | 2004-11-04 20:05:13 |
| Message-ID: | x7sm7p9y86.fsf@yertle.int.kciLink.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
>>>>> "DP" == David Parker <dparker(at)tazznetworks(dot)com> writes:
DP> I would like to be able to truncate all of the tables in a schema
DP> without worrying about FK constraints. I tried issuing a "SET
DP> CONSTRAINTS ALL DEFERRED" before truncating, but I still get
DP> constraint errors. Is there a way to do something like:
Why don't you truncate your tables in an order that won't violate
FK's? Or do you have circular references?
--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Vivek Khera, Ph.D. Khera Communications, Inc.
Internet: khera(at)kciLink(dot)com Rockville, MD +1-301-869-4449 x806
AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Vivek Khera | 2004-11-04 20:08:20 | Re: routine reindexing in 7.4.6/8.0? |
| Previous Message | Thomas F.O'Connell | 2004-11-04 19:43:51 | Re: create a text file from postgres (like Oracle UTL_FILE package) |