Re: question about fixes in v7.4...
От | Robert Treat |
---|---|
Тема | Re: question about fixes in v7.4... |
Дата | |
Msg-id | 1069336326.10335.10728.camel@camel обсуждение исходный текст |
Ответ на | Re: question about fixes in v7.4... (Bruce Momjian <pgman@candle.pha.pa.us>) |
Список | pgsql-hackers |
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
В списке pgsql-hackers по дате отправления: