Re: Error OID - Mailing list pgsql-sql

From Yohanes Purnomo
Subject Re: Error OID
Date
Msg-id 1112.222.124.79.135.1196906926.squirrel@email.powweb.com
Whole thread Raw
In response to Re: Error OID  (Guillaume Lelarge <guillaume@lelarge.info>)
List pgsql-sql
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



pgsql-sql by date:

Previous
From: Gerardo Herzig
Date:
Subject: Re: plpythonu and "hello concurrent world"
Next
From: "Sabin Coanda"
Date:
Subject: execute system command from storage procedure