Re: JDBC driver bug?

Heikki Linnakangas  writes:
> YourSoft wrote:
>> When you call a pgsql stored procedure (with PreparedStatement), that 
>> calls an other stored procedure, and you recall the stored procedure 
>> after dropping and recreating second stored procedure, the calling will 
>> throw an exception with:

> That's a known issue. The first time you call the procedure, it's 
> compiled and cached. The second time you call it, the cached plan is no 
> longer valid because the function it depends on has been dropped and 
> recreated.

> The good news is that Tom Lane has added support for plan invalidation 
> for 8.3 branch, so this should be fixed in the next major release.

This behavior will not change in 8.3, because I have no intention of
including function invalidation in the patch.  The correct answer is
"don't do that --- use CREATE OR REPLACE FUNCTION instead".

			regards, tom lane