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

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