Robert Haas writes:
should handle it better, but I'm not sure how hard that would be to
implement.
On Mon, Mar 5, 2012 at 6:52 AM, wrote:
I found some unexpected behaviour when changing the schema search path in
combination with plpgsql functions (may be true for other function types
too, did not check). This occurs both in 9.1.2 (on Fedora, 64 bit) and 8.4.9
(Centos 6, 32 bit). I created a small example run with psql, to demonstrate
this.
I have a vague feeling this is a known issue. It sure seems like weI found some unexpected behaviour when changing the schema search path in
combination with plpgsql functions (may be true for other function types
too, did not check). This occurs both in 9.1.2 (on Fedora, 64 bit) and 8.4.9
(Centos 6, 32 bit). I created a small example run with psql, to demonstrate
this.
should handle it better, but I'm not sure how hard that would be to
implement.
the original search_path. There's been talk of adjusting that behavior
but I'm worried that we might break as many cases as we fix ...
regards, tom lane
