Re: [GENERAL] Delete cascade trigger runs security definer - postgresql
This is a discussion on Re: [GENERAL] Delete cascade trigger runs security definer - postgresql ; Craig Ringer writes: > Is the search_path reset in some way that's not visible in > pg_catalog.pg_settings when the ON DELETE CASCADE is issued? No, I don't believe so. Perhaps your test case was simply fooled by plan caching within ...
 |
| | LinkBack | Thread Tools | Display Modes |
|
#1
11-14-2008, 02:19 PM
| |||
| |||
 Re: [GENERAL] Delete cascade trigger runs security definer > Is the search_path reset in some way that's not visible in > pg_catalog.pg_settings when the ON DELETE CASCADE is issued? No, I don't believe so. Perhaps your test case was simply fooled by plan caching within the trigger function? In general the solution to this type of problem is to attach a search_path setting to any function that might be invoked via untrusted users. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general  |
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
All times are GMT -4. The time now is 11:09 AM.
