Re: [BUGS] BUG #3599: Wrong search_path inside a function

2007-09-04 Thread Tom Lane
"Alexis Beuraud" <[EMAIL PROTECTED]> writes: > EXECUTE (' set search_path to ' || p_schemaName ); setting the search > path here! > FOR result in > select i > from TableT > loop > return next result; > END LOOP; The reason that doesn't do what you expect is that the plan for the SELECT

[BUGS] BUG #3599: Wrong search_path inside a function

2007-09-04 Thread Alexis Beuraud
The following bug has been logged online: Bug reference: 3599 Logged by: Alexis Beuraud Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.4 Operating system: Windows 2000 Professional Description:Wrong search_path inside a function Details: The function 'set