When grilled further on (Mon, 16 Feb 2004 07:39:25 -0500), Terry Lee Tucker <[EMAIL PROTECTED]> 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
pgp00000.pgp
Description: PGP signature
