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: PQnoti

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 retu

[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 wor