[Pgpool-general] insert with select
shrdswann at comcast.net
shrdswann at comcast.net
Thu Jul 2 17:58:15 UTC 2009
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>
More information about the Pgpool-general
mailing list