> I found the following bug??:
> 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:
>
> org.postgresql.util.PSQLException: ERROR: function with OID 63315074
does not exist
Actually, that's a feature, and it has nothing to do with JDBC.
Static SQL in PL/pgSQL ist parsed when you first execute the
function, and the execution plan is retained and used in subsequent
invocations.
If you want a function to use a database object that is dropped and
recreated with the same name, you should use dynamic SQL.
Yours,
Laurenz Albe
