| From: | Rod Taylor <pg(at)rbt(dot)ca> |
|---|---|
| To: | Don Sceifers <dsceifers(at)harvestadsdepot(dot)com> |
| Cc: | PostgreSQL Development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: question about fixes in v7.4... |
| Date: | 2003-11-19 20:01:12 |
| Message-ID: | 1069272071.4662.42.camel@jester |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Wed, 2003-11-19 at 11:17, 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?
At this time function bodies do not have the dependency tracking
capabilities that a majority of the system has, so it is unable to
complain when you remove or alter an object it depends on.
With SQL functions it should be feasible. For functions that build
queries on the fly this will be virtually impossible.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kurt Roeckx | 2003-11-19 20:07:34 | Re: [PATCHES] SRA Win32 sync() code |
| Previous Message | Hans-Jürgen Schönig | 2003-11-19 19:57:03 | Re: Commercial binary support? |