From: | Robert Creager <Robert_Creager(at)LogicalChaos(dot)org> |
---|---|
To: | Terry Lee Tucker <terry(at)esc1(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Dazed and Confused |
Date: | 2004-02-16 12:58:33 |
Message-ID: | 20040216055833.126ba856.Robert_Creager@LogicalChaos.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
--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--
From | Date | Subject | |
---|---|---|---|
Next Message | Mark Gibson | 2004-02-16 13:54:24 | Re: postgresql system column errors |
Previous Message | Terry Lee Tucker | 2004-02-16 12:39:25 | Dazed and Confused |