When grilled further on (Mon, 16 Feb 2004 07:39:25 -0500),
Terry Lee Tucker <terry@esc1.com> confessed:
> as in, \i cust/cust_preupd_func.plsql, I get an error. The error is:
> psql:logs/logs_preupd_func.plsql:132: ERROR: ProcedureCreate: cannot change
> return type of existing function.
> Use DROP FUNCTION first.
Per the error message, execute DROP FUNCTION function_name( ) before trying to
CREATE FUNCTION.
I believe OPAQUE is deprecated, and the return type of TRIGGER should be used.
But, I still have a trigger which I have not updated that is OPAQUE, and it
loads just find after emitting:
psql:dbTriggers.sql:33: WARNING: changing return type of function
observations_trigger from "opaque" to "trigger"
Cheers,
Rob
--
05:53:40 up 1 day, 13:36, 2 users, load average: 0.07, 0.17, 0.33
Linux 2.4.21-0.13_test #60 SMP Sun Dec 7 17:00:02 MST 2003
