"Christopher Hotchkiss" <christopher.a.hotchk...@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
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
