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

"Christopher Hotchkiss" <christopher(dot)a(dot)hotchkiss(at)jpmchase(dot)com> writes:
> 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');

I think what you've got here is a pgAdmin bug, because I see no such
behavior using psql and pg_dump. Suggest reporting it on the pgAdmin
mailing lists.

regards, tom lane