On Wed, 2003-11-19 at 22:50, Bruce Momjian wrote:
> Don Sceifers wrote:
> > My company is fairly new at Postgresql, but we have hit a problem, where
> > we modify a table using ALTER, and our stored procedures stop working. We
> > have a grasp as to why this happens, but I was wondering if this v7.4
> > upgrade fixes this issue?
>
> This is a known issue. There is no way for us to know what stored
> tables/columns you are using in your function. You might find that
> reconnecting to the database after the ALTER will fix the problem. We
> do cache function code, so reconnecting will erase that cache.
>
Would it be worth putting in a partial implementation? I'm thinking
specifically about functions that return table types. Could they be
hooked up with dependency information and made to complain?
Robert Treat
--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL