Skip site navigation (1) Skip section navigation (2)


From: Rod Taylor <rbt(at)zort(dot)ca>
To: PostgreSQL Patches <pgsql-patches(at)postgresql(dot)org>
Subject: Truncate
Date: 2002-08-20 03:45:52
Message-ID: 1029815153.86008.18.camel@jester (view raw or flat)
Lists: pgsql-patches
# Disallow TRUNCATE on tables that are involved in referential

The issue with finding and removing foreign key constraints is no longer
an issue, so please apply the attached.

It does NOT check for rules or on delete triggers (old style foreign
keys) as those are difficult to deal with (remove, truncate, re-add).

Please add files:

Attachment: truncate.out
Description: text/plain (879 bytes)
Attachment: truncate.sql
Description: text/x-sql (483 bytes)
Attachment: truncate.patch
Description: text/plain (4.8 KB)


pgsql-patches by date

Next:From: Rod TaylorDate: 2002-08-20 03:52:28
Subject: Re: Documentation update (pg_get_fkeydef,
Previous:From: Tom LaneDate: 2002-08-19 21:21:39
Subject: Re: functions-matching correct?

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group