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

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Don Sceifers <dsceifers(at)harvestadsdepot(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: question about fixes in v7.4...
Date: 2003-11-20 03:50:41
Message-ID: 200311200350.hAK3off12917@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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.

If still have problems, please report the ALTER command and function
that is causing the problem.

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2003-11-20 04:36:30 Re: commenting on polymorphic aggregates possible?
Previous Message Christopher Kings-Lynne 2003-11-20 01:21:45 Re: logical column position