Pam Withnall <[EMAIL PROTECTED]> writes: > in my java code I am creating 3 temporary tables, then calling a stored > procedure which calls another stored procedure. > then I drop the temporary tables. > the first time around , eveything is OK , then when repeating the action I > get > "ExecOpenScanR: failed to open relation 2808495 " If you're using plpgsql, you can't drop and recreate temp tables between procedure executions, because the cached query plans for the procedure will still refer to the old version of the tables. Either create the temp table *once* per backend, or use pltcl, which doesn't try to cache query plans. regards, tom lane