Two things:
1. Is there an etiquette to asking a question on this list? ( I ask because I
haven't received any response to any question I've asked)
2. I've been trying to get pgpool to work for a month with no luck. It will run
one node fine - but i get errors about non-existent values in tables when I try
replication. Does pgpool support replication if my "insert" contains a
"select"? In the example below, the highest message_id in the table may be
282222565 - yet the select came up with 282222570 as the message_id.
Ex:
2009-07-02 13:31:59 EDT 172.33.33.186(41501) 22450DETAIL: Key
(message_id)=(282222570) is not present in table "message".
2009-07-02 13:31:59 EDT 172.33.33.186(41501)
22450STATEMENT:
insert into message_recipient (recipient_id, message_id, is_mapped,
is_calculated, is_envelope, reason_id, action) select id, '282222570', '0',
'1', '0', '1', NULL from recipient where local = 'nimsi.sssss' and domain
= 'xxx.yyy'
2009-07-02 13:35:00 EDT 172.33.33.186(42197) 22490ERROR: insert or update on
table "message_recipient" violates foreign key constraint "rc_rcpnt_map_msg_id"
Sherrod Swann
_______________________________________________
Pgpool-general mailing list
[email protected]
http://pgfoundry.org/mailman/listinfo/pgpool-general
