| Lists: | pgsql-patches |
|---|
| From: | Rod Taylor <rbt(at)zort(dot)ca> |
|---|---|
| To: | pgsql-patches(at)postgresql(dot)org |
| Subject: | Truncate |
| Date: | 2002-05-12 17:21:00 |
| Message-ID: | 20020512172100.GA41560@knight |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-patches |
Added check to Truncate to disallow the command on tables that have on
delete triggers, including foreign keys, and delete rules.
Finishes 'Disallow TRUNCATE on tables that are involved in referential
constraints'
New truncate regression test should include permission checks at some
point in the future.
| Attachment | Content-Type | Size |
|---|---|---|
| truncate.sql | text/x-sql | 362 bytes |
| From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
|---|---|
| To: | Rod Taylor <rbt(at)zort(dot)ca> |
| Cc: | pgsql-patches(at)postgresql(dot)org |
| Subject: | Re: Truncate |
| Date: | 2002-06-05 18:28:13 |
| Message-ID: | 200206051828.g55ISDD28766@candle.pha.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-patches |
Your patch has been added to the PostgreSQL unapplied patches list at:
http://candle.pha.pa.us/cgi-bin/pgpatches
I will try to apply it within the next 48 hours.
---------------------------------------------------------------------------
Rod Taylor wrote:
> Added check to Truncate to disallow the command on tables that have on
> delete triggers, including foreign keys, and delete rules.
>
> Finishes 'Disallow TRUNCATE on tables that are involved in referential
> constraints'
>
>
> New truncate regression test should include permission checks at some
> point in the future.
[ Attachment, skipping... ]
[ Attachment, skipping... ]
[ Attachment, skipping... ]
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
| From: | "Rod Taylor" <rbt(at)zort(dot)ca> |
|---|---|
| To: | "Bruce Momjian" <pgman(at)candle(dot)pha(dot)pa(dot)us> |
| Cc: | <pgsql-patches(at)postgresql(dot)org> |
| Subject: | Re: Truncate |
| Date: | 2002-06-05 21:54:27 |
| Message-ID: | 095301c20cdb$909e74b0$fe01a8c0@jester |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-patches |
There were good arguements for not having this patch applied.
Please ignore it :)
--
Rod
----- Original Message -----
From: "Bruce Momjian" <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: "Rod Taylor" <rbt(at)zort(dot)ca>
Cc: <pgsql-patches(at)postgresql(dot)org>
Sent: Wednesday, June 05, 2002 2:28 PM
Subject: Re: [PATCHES] Truncate
>
> Your patch has been added to the PostgreSQL unapplied patches list
at:
>
> http://candle.pha.pa.us/cgi-bin/pgpatches
>
> I will try to apply it within the next 48 hours.
>
> --------------------------------------------------------------------
-------
>
>
> Rod Taylor wrote:
> > Added check to Truncate to disallow the command on tables that
have on
> > delete triggers, including foreign keys, and delete rules.
> >
> > Finishes 'Disallow TRUNCATE on tables that are involved in
referential
> > constraints'
> >
> >
> > New truncate regression test should include permission checks at
some
> > point in the future.
>
> [ Attachment, skipping... ]
>
> [ Attachment, skipping... ]
>
> [ Attachment, skipping... ]
>
> >
> > ---------------------------(end of
broadcast)---------------------------
> > TIP 5: Have you checked our extensive FAQ?
> >
> > http://www.postgresql.org/users-lounge/docs/faq.html
>
> --
> Bruce Momjian | http://candle.pha.pa.us
> pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
> + If your life is a hard drive, | 830 Blythe Avenue
> + Christ can be your backup. | Drexel Hill, Pennsylvania
19026
>
| From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
|---|---|
| To: | Rod Taylor <rbt(at)zort(dot)ca> |
| Cc: | pgsql-patches(at)postgresql(dot)org |
| Subject: | Re: Truncate |
| Date: | 2002-06-06 00:07:48 |
| Message-ID: | 200206060007.g5607mV06994@candle.pha.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-patches |
Patch withdrawn by author.
---------------------------------------------------------------------------
Rod Taylor wrote:
> Added check to Truncate to disallow the command on tables that have on
> delete triggers, including foreign keys, and delete rules.
>
> Finishes 'Disallow TRUNCATE on tables that are involved in referential
> constraints'
>
>
> New truncate regression test should include permission checks at some
> point in the future.
[ Attachment, skipping... ]
[ Attachment, skipping... ]
[ Attachment, skipping... ]
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026