Guillaume Lelarge write: > When you run a function for the first time in the session, PostgreSQL > keeps in cache some information... query plans for example. > > > When you run it a second time, it uses the query plan in cache. As > tmpTtlRekening has been drop at the end of the first run, its OID will > change but the old OID is still in cache. So PostgreSQL tries to get > information from the old temp table. >
Guillaume Lelarge many thanks for your information Regards Yohanes Purnomo ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster