>>>>> "DP" == David Parker <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] Rockville, MD +1-301-869-4449 x806 AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/ ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend