From: | Terry Lee Tucker <terry(at)esc1(dot)com> |
---|---|
To: | Robert Creager <Robert_Creager(at)logicalchaos(dot)org> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Dazed and Confused |
Date: | 2004-02-16 14:45:10 |
Message-ID: | 200402160945.10538.terry@esc1.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi Robert,
I changed the return type from OPAQUE to TRIGGER and the trigger function
reloaded without any complaint. I suppoe that when I loaded this new version
(with the output from pg_dumpall) that the return type was automatically set
to TRIGGER? I couldn't understand the fact that the code initally loaded
without complaint, but now, upon trying to reload, I was getting an error
with the same code.
Anyway, thanks for the response...
On Monday 16 February 2004 07:58 am, Robert Creager saith:
> 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
--
Work: 1-336-372-6812
Cell: 1-336-363-4719
email: terry(at)esc1(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2004-02-16 15:26:12 | Re: making tsearch2 dictionaries |
Previous Message | Fischer Ulrich | 2004-02-16 13:57:47 | tsearch2: restoring problem |