Re: Dazed and Confused

--Multipart_Mon__16_Feb_2004_05_58_33_-0700_=.D'CQ(RnFWTXyP4
Content-Type: text/plain; charset=US-ASCII
Content-Disposition: inline
Content-Transfer-Encoding: 7bit

When grilled further on (Mon, 16 Feb 2004 07:39:25 -0500),
Terry Lee Tucker <terry(at)esc1(dot)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

--Multipart_Mon__16_Feb_2004_05_58_33_-0700_=.D'CQ(RnFWTXyP4
Content-Type: application/pgp-signature

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.2 (GNU/Linux)

iEYEARECAAYFAkAwvnoACgkQLQ/DKuwDYzkulQCgmKAb9O2v/Dqn68Egy7gm9TFe
DZwAnAwDTXgKzzsGtpJ6OIHZOmICIpD1
=xdm5
-----END PGP SIGNATURE-----

--Multipart_Mon__16_Feb_2004_05_58_33_-0700_=.D'CQ(RnFWTXyP4--