Re: [GENERAL] Trouble with PQnotifies()

2012-12-14 Thread seiliki
The following listening worker thread behaves as expected if I insert/delete rows into/from table t1 in psql prompt. My trouble is when the SQL execution worker thread inserts/ deletes rows into/from table t1, the listening worker thread then goes crazy: PQnotifies() always returns NULL

Re: [GENERAL] Trouble with PQnotifies()

2012-12-14 Thread Mark Morgan Lloyd
seil...@so-net.net.tw wrote: The following listening worker thread behaves as expected if I insert/delete rows into/from table t1 in psql prompt. My trouble is when the SQL execution worker thread inserts/ deletes rows into/from table t1, the listening worker thread then goes crazy:

[GENERAL] Trouble with PQnotifies()

2012-12-13 Thread seiliki
Dear gurus, CREATE OR REPLACE RULE r1i AS ON INSERT TO t1 DO NOTIFY NotifyMe; CREATE OR REPLACE RULE r1u AS ON UPDATE TO t1 DO NOTIFY NotifyMe; CREATE OR REPLACE RULE r1d AS ON DELETE TO t1 DO NOTIFY NotifyMe; The main thread in my Windows application launches several worker threads. Several