Skip site navigation (1) Skip section navigation (2)

Re: Triggers on TRUNCATE?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Hannu Krosing <hannu(at)tm(dot)ee>
Cc: Daniel Baldoni <pgsql(at)lcds(dot)com(dot)au>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Triggers on TRUNCATE?
Date: 2004-07-27 02:50:05
Message-ID: 18597.1090896605@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackers
Hannu Krosing <hannu(at)tm(dot)ee> writes:
> Btw, does the right to TRUNCATE come with GRANT DELETE, or must one be a
> superuser to TRUNCATE ?

You have to own the table (or be superuser of course).  This implies the
right to drop its triggers, so TRUNCATE could be seen as dropping
triggers, DELETE, recreate triggers.

			regards, tom lane

In response to

pgsql-hackers by date

Next:From: Daniel BaldoniDate: 2004-07-27 03:27:06
Subject: Re: Triggers on TRUNCATE?
Previous:From: pgsqlDate: 2004-07-27 02:06:28
Subject: Re: Binary Cursors, and the COPY command

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group