TRUNCATE TODO Item

From: Rod Taylor <rbt(at)zort(dot)ca>
To: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: TRUNCATE TODO Item
Date: 2002-08-19 03:13:58
Message-ID: 1029726838.11788.62.camel@jester
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

# Disallow TRUNCATE on tables that are involved in referential
constraints

The above is on the TODO list. Are there any thoughts as to what we
want to do with this? The patch I submitted earlier received heavy
feedback saying it wasn't wanted due to rules and triggers (foreign
keys) being difficult to drop and re-create.

Foreign keys no longer have this issue, as such I'd like to re-apply the
check and prevention of TRUNCATE when a foreign key constraint exists.

Primary reason is to prevent users from shooting their own feet -- yes,
I have structure owners who use Access, MSSql, MySQL, and Oracle on a
regular basis. Oracle and MSSql both (if memory serves) prevents this
case, so it comes as a surprise the first time they run it.

Browse pgsql-hackers by date

  From Date Subject
Next Message Philip Warner 2002-08-19 04:16:27 Re: Function result cacheing - any comments?
Previous Message Christopher Kings-Lynne 2002-08-19 01:37:16 Re: About to update the PostgreSQL Functions in the official PHP Manual