Thread: Truncate
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
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
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 >
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