BUG #5676: When creating a trigger an dummy argument is inserted. - Mailing list pgsql-bugs

From Christopher Hotchkiss
Subject BUG #5676: When creating a trigger an dummy argument is inserted.
Date
Msg-id 201009241540.o8OFevwn080680@wwwmaster.postgresql.org
Whole thread Raw
Responses Re: BUG #5676: When creating a trigger an dummy argument is inserted.  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
The following bug has been logged online:

Bug reference:      5676
Logged by:          Christopher Hotchkiss
Email address:      christopher.a.hotchkiss@jpmchase.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?

pgsql-bugs by date:

Previous
From: Dave Page
Date:
Subject: Re: Fehler beim Installieren von PostgreSQL v8.4.3-1
Next
From: Tom Lane
Date:
Subject: Re: BUG #5676: When creating a trigger an dummy argument is inserted.