Re: search path within trigger

Поиск
Список
Период
Сортировка
От Shoaib Mir
Тема Re: search path within trigger
Дата
Msg-id bf54be870706091021q1659922cj9bea80a36c81c5c7@mail.gmail.com
обсуждение исходный текст
Ответ на search path within trigger  (chester c young <chestercyoung@yahoo.com>)
Список pgsql-sql
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

В списке pgsql-sql по дате отправления:

Предыдущее
От: chester c young
Дата:
Сообщение: search path within trigger
Следующее
От: Kristo Kaiv
Дата:
Сообщение: Re: show index from [table]