Postgres Pro
Downloads
Home   >   mailing lists

Re: plan invalidation vs stored procedures - Mailing list pgsql-hackers

From Marko Kreen
Subject Re: plan invalidation vs stored procedures
Date
Msg-id e51f66da0808050805s65e3636bj6f0369393c4247fe@mail.gmail.com
Whole thread Raw
In response to Re: plan invalidation vs stored procedures  ("Pavel Stehule" <pavel.stehule@gmail.com>)
List pgsql-hackers
Tree view 
On 8/5/08, Pavel Stehule <pavel.stehule@gmail.com> wrote:
>  >> ERROR:  cannot change return type of existing function
>  >> HINT:  Use DROP FUNCTION first.
>
> you cannot change header of function. It's same as change C header of
> function without complete recompilation.

Thats why plan invalidation for DROP+CREATE is needed.

-- 
marko

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Status of DISTINCT-by-hashing work
Next
From: Tom Lane
Date:
Subject: Re: small improvement in buffread common