[SQL NOTIFY Help] sending NOTIFY to the external program
От | |
---|---|
Тема | [SQL NOTIFY Help] sending NOTIFY to the external program |
Дата | |
Msg-id | 47230CE166B64744B0120173E4C2161E0103E69C@BLR-EC-MBX01.wipro.com обсуждение исходный текст |
Ответы |
Re: [SQL NOTIFY Help] sending NOTIFY to the external program
|
Список | pgsql-sql |
Hi, In one of our project we are supposed to send the notifications regarding any row modifications in a perticular table to the external application which will be implementing the listen event for the same. We are using the postgress version 8.0.3. we have observed that pgNotify structure in "libpq-fe.h" file is having the following structure; typedef struct pgNotify { char *relname; /* notification condition name */ int be_pid; /* process ID of notifying server process */ char *extra; /* notification parameter */ /* Fields below here are private to libpq; apps should not use 'em */ struct pgNotify *next; /* list link */ } PGnotify; But, by default only relname and be_pid are used. The technical document also mentions that extra attribute is not used and by default it will be null. Can anybody clarify whether we can pass the primary key value of the record modified in the extra attribute of this structure? If not any help regarding the same will be appreciated. Thanks in Advance, Ramachandra B.S. The information contained in this electronic message and any attachments to this message are intended for the exclusive useof the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient,you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately and destroy allcopies of this message and any attachments. WARNING: Computer viruses can be transmitted via email. The recipient should check this email and any attachments for thepresence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email. www.wipro.com
В списке pgsql-sql по дате отправления: