BUG #5676: When creating a trigger an dummy argument is inserted.

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?

Responses

Browse pgsql-bugs by date

  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