search path within trigger
This is a discussion on search path within trigger within the pgsql Sql forums, part of the PostgreSQL category; --> within a table pl/pgsql trigger, what's the easiest way to see if the schema for the triggered table is ...
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-19-2008, 03:28 PM
| ||||
| ||||
 search path within trigger within a table pl/pgsql trigger, what's the easiest way to see if the schema for the triggered table is the same as search_path? __________________________________________________ __________________________________ Be a better Globetrotter. Get better travel answers from someone who knows. Yahoo! Answers - Check it out. http://answers.yahoo.com/dir/?link=list&sid=396545469 ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend      |
|
04-19-2008, 03:28 PM
| ||||
| ||||
| Re: search path within trigger Did you try 'select current_schema' ? -- Shoaib Mir EnterpriseDB (www.enterprisedb.com) On 6/9/07, chester c young <chestercyoung@yahoo.com> wrote: > > within a table pl/pgsql trigger, what's the easiest way to see if the > schema for the triggered table is the same as search_path? > > > > > __________________________________________________ __________________________________ > Be a better Globetrotter. Get better travel answers from someone who > knows. Yahoo! Answers - Check it out. > http://answers.yahoo.com/dir/?link=list&sid=396545469 > > ---------------------------(end of broadcast)--------------------------- > TIP 6: explain analyze is your friend > |
Linear Mode
