On Thu, Sep 26, 2013 at 8:52 AM, Tom Lane <t...@sss.pgh.pa.us> wrote: > Lonni J Friedman <netll...@gmail.com> writes: >> Thanks for your reply. This sounds like a relatively simple >> workaround, so I'll give it a try. Is the search_path of the remote >> session that postgres_fdw forces considered to be intentional, >> expected behavior, or is it a bug? > > It's intentional. > > Possibly more to the point, don't you think your trigger function is > rather fragile if it assumes the caller has provided a particular > search path setting?
To be honest, I don't have much experience with functions, and was using the trigger function from the official documentation: http://www.postgresql.org/docs/9.3/static/ddl-partitioning.html -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general