Re: Sending several commands simultaneously to PostgreSQL 8.4 - Mailing list pgsql-general

From Alexander Farber
Subject Re: Sending several commands simultaneously to PostgreSQL 8.4
Date
Msg-id CAADeyWgLeJZHrR7DLmGJ5k6h6NQJoEgJn-koFrQ_EOhL+W6m-w@mail.gmail.com
Whole thread Raw
In response to Sending several commands simultaneously to PostgreSQL 8.4  (Alexander Farber <alexander.farber@gmail.com>)
Responses Re: Sending several commands simultaneously to PostgreSQL 8.4
Re: Sending several commands simultaneously to PostgreSQL 8.4
List pgsql-general
To make my question more concrete:
if I'd like to round-robin 6 PostgreSQL connections
from my Perl script - how should I change my code:

        eval {
                my $dbh = DBI->connect_cached(DSN, DBUSER, DBPASS, {
                    AutoCommit => 1,
                    PrintWarn => 1,
                    PrintError => 1,
                    RaiseError => 1,
                    FetchHashKeyName => 'NAME_lc',
                    pg_enable_utf8 => 1
                });
                ..........SQL commands.......
        };
        warn $@ if $@;
}

I.e. I don't understand how to combine
this with the DBI connect_cached() call?

How to make it return different connections?

Thanks
Alex


pgsql-general by date:

Previous
From: Chris Ernst
Date:
Subject: Re: pg_Restore
Next
From: Alexander Farber
Date:
Subject: Re: Sending several commands simultaneously to PostgreSQL 8.4