"Andrew Hammond" <andrew.george.hammond at gmail.com> writes:
> On 6/5/07, Christopher Browne <cbbrowne at ca.afilias.info> wrote:
>> Jeff Davis wrote:
>> > On Tue, 2007-06-05 at 14:08 -0400, Vivek Khera wrote:
>> >
>> >> On Jun 3, 2007, at 3:31 AM, Pat Maddox wrote:
>> >>
>> >>
>> >>> lots of "relation with OID ##### does not exist" errors.  I found the
>> >>> FAQ at http://www.postgresql.org/docs/faqs.FAQ.html#item4.19 but I
>> >>> don't quite understand what I need to do.
>> >>>
>> >> quit/restart your application so it opens new connections to the
>> >> database and won't try to use old execution plans which are now invalid.
>> >>
>> >>
>> >
>> > I'd like to add that this problem will be fixed in PostgreSQL 8.3.
>> >
>> That's interesting.
>>
>> I'd been hearing vague comments about "real soon now" during both 8.1
>> and 8.2 branches; is there some pointer yet to document what is
>> resolving this?
>
> The design discussion
>
> http://groups.google.com/group/pgsql.hackers/browse_thread/thread/5fd6a9e09a6b3946/541168104f524348?lnk=gst&rnum=2#541168104f524348
>
> The first time is saw a "hey, this is now done".
>
> http://groups.google.com/group/pgsql.hackers/browse_thread/thread/eb387cca4c2a3127/c26caab2c36d2aad?lnk=gst&q=invalidation&rnum=3#c26caab2c36d2aad

Excellent.  I'll add a note to the FAQ that this is believed to be
resolved in v8.3.
-- 
let name="cbbrowne" and tld="ca.afilias.info" in String.concat "@" [name;tld];;
<http://dba2.int.libertyrms.com/>
Christopher Browne
(416) 673-4124 (land)