Re: Must be table owner to truncate?
От
Kevin Hunter
Тема
Re: Must be table owner to truncate?
Дата
Msg-id
48905243.7030503@earlham.edu
Ответ на
Re: Must be table owner to truncate? (Said Ramirez)
Список
Дерево обсуждения
Must be table owner to truncate? smiley2211 <msramsey22@gmail.com>
Re: Must be table owner to truncate? Tom Lane <tgl@sss.pgh.pa.us>
Re: Must be table owner to truncate? smiley2211 <msramsey22@gmail.com>
Re: Must be table owner to truncate? Said Ramirez <sramirez@vonage.com>
Re: Must be table owner to truncate? Kevin Hunter <hunteke@earlham.edu>
Re: Must be table owner to truncate? Ragnar <gnari@hive.is>
Re: Must be table owner to truncate? Robert Treat <xzilla@users.sourceforge.net>
Re: Must be table owner to truncate? Stephen Frost <sfrost@snowman.net>
At 3:45p -0400 on Mon, 28 Jul 2008, Said Ramirez wrote: > According to the documentation, > http://www.postgresql.org/docs/current/interactive/sql-truncate.html , > only the owner can truncate a table. Which means the non-owner must > either log in/ switch roles as the owner, or they can just run a DELETE. Well that's interesting. From a security standpoint, what's the difference between an unqualified DELETE and a TRUNCATE? Also interesting to note that TRUNCATE is transaction safe, but not MVCC safe. Good to know, good to know ... Kevin
В списке pgsql-general по дате отправления
