Re: partitioned table + postgres_FDW not working in 9.3 - Mailing list pgsql-general

From Tom Lane
Subject Re: partitioned table + postgres_FDW not working in 9.3
Date
Msg-id 27169.1380210725@sss.pgh.pa.us
Whole thread Raw
In response to Re: partitioned table + postgres_FDW not working in 9.3  (Lonni J Friedman <netllama@gmail.com>)
Responses Re: partitioned table + postgres_FDW not working in 9.3  (Lonni J Friedman <netllama@gmail.com>)
List pgsql-general
Lonni J Friedman <netllama@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?

            regards, tom lane


pgsql-general by date:

Previous
From: Lonni J Friedman
Date:
Subject: Re: partitioned table + postgres_FDW not working in 9.3
Next
From: Lonni J Friedman
Date:
Subject: Re: partitioned table + postgres_FDW not working in 9.3