Horton

Re: Patch: plan invalidation vs stored procedures

Andrew Dunstan <andrew@dunslane.net>

View thread View on postgr.es
From: Andrew Dunstan <andrew@dunslane.net>
To: Asko Oja <ascoja@gmail.com>
Cc: Dimitri Fontaine <dfontaine@hi-media.com>, Tom Lane <tgl@sss.pgh.pa.us>, Joshua Drake <jd@commandprompt.com>, Bruce Momjian <bruce@momjian.us>, Gregory Stark <stark@enterprisedb.com>, Hannu Krosing <hannu@2ndquadrant.com>, Pavel Stehule <pavel.stehule@gmail.com>, pgsql-hackers@postgresql.org, David Fetter <david@fetter.org>, Martin Pihlak <martin.pihlak@gmail.com>
Date: 2008-08-20T12:50:27Z
Lists: pgsql-hackers 

Asko Oja wrote:
> I do get the impression that Tom who would prefer to get all the pl's 
> out of PostgreSQL and live happily ever after with pure SQL standard.
>
>

I have not seen the slightest evidence of this, and don't believe it for 
a minute.

I understand some of the frustration you are feeling, but statements 
like this don't help anything.

(And yes, I too have recently been bitten nastily by cached plan 
problems, and want to see them fixed. I rather like Simon's suggestion 
of a command or function that would clear the plan cache.)

cheers

andrew