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

"Christopher Hotchkiss" <christopher.a.hotchkiss@jpmchase.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