Re: Sending several commands simultaneously to PostgreSQL 8.4

Поиск
Список
Период
Сортировка
От Alexander Farber
Тема Re: Sending several commands simultaneously to PostgreSQL 8.4
Дата
Msg-id CAADeyWgLeJZHrR7DLmGJ5k6h6NQJoEgJn-koFrQ_EOhL+W6m-w@mail.gmail.com
обсуждение исходный текст
Ответ на Sending several commands simultaneously to PostgreSQL 8.4  (Alexander Farber <alexander.farber@gmail.com>)
Ответы Re: Sending several commands simultaneously to PostgreSQL 8.4  (Alexander Farber <alexander.farber@gmail.com>)
Re: Sending several commands simultaneously to PostgreSQL 8.4  (Jeff Janes <jeff.janes@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Chris Ernst
Дата:
Сообщение: Re: pg_Restore
Следующее
От: Alexander Farber
Дата:
Сообщение: Re: Sending several commands simultaneously to PostgreSQL 8.4