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.
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 |