[Pgpool-general] insert with select

[J. Carlos Muro]

Hi Sherrod!

1. I dont think there is an etiquette. Maybe one of these:
  - a: just nobody new the answer
  - b: not high activity in the list
  - c: b+a
  - d: somebody knows the answer but either he/she could not find the time
to answer, either he/she didn't even yet read your message.

I have also launched a couple of questions with no answer at all, though I
am so glad that at least the big Tatsuo got somehow interested on it :) )))

2. I dont really understand that statement of yours.. You talk about the
highest message_id, but i dont see any 'MAX(message_id)' in it.. I just see
there "...select id, '282222570',...", that is, you are hard writing it. Or,
are you talking about a "nextval('your_sequence')" that is returning
282222570? How many backends are you using in your setup? Can you send the
real query? I just see in the logs:

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'

I dont think pgpool is not supporting inserts with nested selects.. Maybe I
will find the time a bit later, I will test it in my database..

Cheers,
J. Carlos Muro

2009/7/2 <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
>
> _______________________________________________
> Pgpool-general mailing list
> Pgpool-general at pgfoundry.org
> http://pgfoundry.org/mailman/listinfo/pgpool-general
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://pgfoundry.org/pipermail/pgpool-general/attachments/20090703/9f4079b6/attachment-0001.html>