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 whole thread)
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.patch
Description: text/plain (4.8 KB)
Attachment: truncate.sql
Description: text/x-sql (483 bytes)
Attachment: truncate.out
Description: text/plain (879 bytes)


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