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

Поиск
Список
Период
Сортировка
От Christopher Hotchkiss
Тема BUG #5676: When creating a trigger an dummy argument is inserted.
Дата
Msg-id 201009241540.o8OFevwn080680@wwwmaster.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #5676: When creating a trigger an dummy argument is inserted.  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Dave Page
Дата:
Сообщение: Re: Fehler beim Installieren von PostgreSQL v8.4.3-1
Следующее
От: Tom Lane
Дата:
Сообщение: Re: BUG #5676: When creating a trigger an dummy argument is inserted.