Re: Dazed and Confused

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