Tom Lane said:
> "John Sidney-Woollett" <[EMAIL PROTECTED]> writes:
>> Please can someone explain why Postgres cannot recognize that objects
>> (referenced by pl/pgsql functions) whose OID no longer exists could in
>> fact be found (as new objects) if the function was reparsed and compiled
>> again
On Thu, Apr 22, 2004 at 02:07:39PM +0100, John Sidney-Woollett wrote:
> There are loads of instances (db in flux, move table to another schema
> etc) why you might want/need to drop a table, and recreate it. But in
> Postgres, you have to reapply all DDL statements to the db that referenced
> that
Alvaro Herrera said:
> Actually, in your example the only thing you need to do is close the
> connection and reconnect. I agree it would be nice to recompile the
> function automatically, but it's not as bad as you put it.
Thanks, I wasn't aware of that.
John Sidney-Woollett
---
Please can someone explain why Postgres cannot recognize that objects
(referenced by pl/pgsql functions) whose OID no longer exists could in
fact be found (as new objects) if the function was reparsed and compiled
again.
Here's an example:
Create table t1 (f1 integer);
insert into t1 values (1)
