Re: cache lookup failed

From: <cnliou(at)eurosport(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Re: cache lookup failed
Date: 2001-09-15 01:27:18
Message-ID: 200109150127.125a@lh00.opsion.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Suppose you create a function function1 and a trigger
that calls function1. Then you drop function1 and
re-create function1. Now you will find that the
trigger can't see function1's existence. trigger (and
other object too) refeerences functions using OID,
not the function name.

I also feel it being inconvient for postgresql to use
OID's instead of object names.

CN

--------------------------------------------------------
You too can have your own email address from Eurosport.
http://www.eurosport.com

Browse pgsql-general by date

  From Date Subject
Next Message Alex Pilosov 2001-09-15 02:35:49 Re: function::plpgsql::returning resultset
Previous Message Martijn van Oosterhout 2001-09-15 01:27:08 Re: Abort state on duplicated PKey in transactions