pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedsearch path within trigger
2+ messages / 2 participants
[nested] [flat]
* search path within trigger
@ 2007-06-09 16:56 chester c young <chestercyoung@yahoo.com>
0 siblings, 1 reply; 2+ messages in thread
From: chester c young @ 2007-06-09 16:56 UTC (permalink / raw)
To: pgsql-sql
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
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: search path within trigger
@ 2007-06-09 17:21 Shoaib Mir <shoaibmir@gmail.com>
parent: chester c young <chestercyoung@yahoo.com>
0 siblings, 0 replies; 2+ messages in thread
From: Shoaib Mir @ 2007-06-09 17:21 UTC (permalink / raw)
To: chester c young <chestercyoung@yahoo.com>; +Cc: 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
>
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2007-06-09 17:21 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-06-09 16:56 search path within trigger chester c young <chestercyoung@yahoo.com>
2007-06-09 17:21 ` Shoaib Mir <shoaibmir@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox