Re: Missing OID rant - Mailing list pgsql-general

From Jan Wieck
Subject Re: Missing OID rant
Date
Msg-id 408825BC.3020008@Yahoo.com
Whole thread Raw
In response to Re: Missing OID rant  ("John Sidney-Woollett" <johnsw@wardbrook.com>)
List pgsql-general
John Sidney-Woollett wrote:

> Tom Lane said:

>> Yup, this is on the TODO list, and has been for awhile:
>>
>> * Flush cached query plans when their underlying catalog data changes
>
> Is the query plan cached for the life of the session, or the life of the
> cache/database/postmaster session?

DB connection is the lifetime of PL/pgSQL cached plans.

>
> Isn't removing the plan from the cache, and marking objects invalid two
> separate although related issues?

It is.

>
>>> I don't know, but cannot believe that it would be hard to implement
>>> this,
>>
>> Step right up ...
>
> Believe you me, you don't want my code - it's been quite a few years since
> I've done any C programming, a patch I produced might set Postgres back 5
> years!!

Well, that's what I do with French people, I convince them that it hurts
less if they rather talk English or German instead of me uttering
something in their language.

>
> BTW, I was only highlighting the issue because the missing OID message bit
> me in the ass again today, and I didn't realise that it existed as an
> outstanding todo item.
>
> I guess that there are other missing features like exception handling and
> nested transactions which are more important and need attention more
> urgently...

Exactly, and because of that we want you to do the easy stuff with the
cache invalidation, so that we have the time to think about the others.


Jan

>
> John Sidney-Woollett
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org


--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck@Yahoo.com #


pgsql-general by date:

Previous
From: "scott.marlowe"
Date:
Subject: Re: 7.3.4 on Linux: UPDATE .. foo=foo+1 degrades massivly
Next
From: "Glen Parker"
Date:
Subject: Re: 7.3.4 on Linux: UPDATE .. foo=foo+1 degrades massivly