Thread: Truncate

Truncate

From
Rod Taylor
Date:
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

Re: Truncate

From
Bruce Momjian
Date:
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@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Re: Truncate

From
"Rod Taylor"
Date:
There were good arguements for not having this patch applied.

Please ignore it :)
--
Rod
----- Original Message -----
From: "Bruce Momjian" <pgman@candle.pha.pa.us>
To: "Rod Taylor" <rbt@zort.ca>
Cc: <pgsql-patches@postgresql.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@candle.pha.pa.us               |  (610) 853-3000
>   +  If your life is a hard drive,     |  830 Blythe Avenue
>   +  Christ can be your backup.        |  Drexel Hill, Pennsylvania
19026
>


Re: Truncate

From
Bruce Momjian
Date:
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@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026