| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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 | Content-Type | Size |
|---|---|---|
| truncate.patch | text/plain | 4.8 KB |
| truncate.sql | text/x-sql | 483 bytes |
| truncate.out | text/plain | 879 bytes |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rod Taylor | 2002-08-20 03:52:28 | Re: Documentation update (pg_get_fkeydef, |
| Previous Message | Tom Lane | 2002-08-19 21:21:39 | Re: functions-matching correct? |