From: | "Christopher Hotchkiss" <christopher(dot)a(dot)hotchkiss(at)jpmchase(dot)com> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #5676: When creating a trigger an dummy argument is inserted. |
Date: | 2010-09-24 15:40:57 |
Message-ID: | 201009241540.o8OFevwn080680@wwwmaster.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged online:
Bug reference: 5676
Logged by: Christopher Hotchkiss
Email address: christopher(dot)a(dot)hotchkiss(at)jpmchase(dot)com
PostgreSQL version: 9.0.0
Operating system: Ubuntu 10.04 x64
Description: When creating a trigger an dummy argument is inserted.
Details:
When creating the following trigger:
CREATE TRIGGER c_aud_trg
BEFORE INSERT OR UPDATE OR DELETE
ON ca
FOR EACH ROW
EXECUTE PROCEDURE c_aud_trg_trfunc();
It will actually get created as (using pgAdmin 1.12):
CREATE TRIGGER c_aud_trg
BEFORE INSERT OR UPDATE
ON ca
FOR EACH ROW
EXECUTE PROCEDURE c_aud_trg_func(E'\\x');
If that same trigger is dropped and re-added using what is in the database,
the following shows up:
CREATE TRIGGER c_aud_trg
BEFORE INSERT OR UPDATE
ON ca
FOR EACH ROW
EXECUTE PROCEDURE c_aud_trg_func(E'\\x5c7800');
The trigger fired normally but what is that junk argument?
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2010-09-24 16:03:35 | Re: BUG #5676: When creating a trigger an dummy argument is inserted. |
Previous Message | Tom Lane | 2010-09-24 15:33:25 | Re: Re: [BUGS] BUG #5650: Postgres service showing as stopped when in fact it is running |