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

Truncate

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)
Thread:
Lists: pgsql-patches
# Disallow TRUNCATE on tables that are involved in referential
constraints


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:
src/test/regress/expected/truncate.out
src/test/regress/sql/truncate.sql

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)

Responses

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-2014 The PostgreSQL Global Development Group