Re: question about fixes in v7.4...

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