[Pgpool-general] insert with select

[shrdswann at comcast.net]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://pgfoundry.org/pipermail/pgpool-general/attachments/20090702/633d7ed1/attachment.html>