use of PQconnectdb and PQfinish in a shared library

Поиск
Список
Период
Сортировка
От Alex Sandini
Тема use of PQconnectdb and PQfinish in a shared library
Дата
Msg-id 3DBD1878.6060706@keyware.com
обсуждение исходный текст
Список pgsql-general
Hi all,
Using PQconnectdb and PQfinish each time a function is called from a
client, the function run well the first time is invoqued, but fails on
any subsequent call, at the first PQexec call, with respective kill -9
of the child process on the server.

To get it working, i've done something like:

static bool bfirsttime = false;
int4 any_function (text buf, int4 num )
{
    if( !bfirsttime ) {
        dbconn = PQconnectdb( conninfo );
        bfirsttime = true;
    }

    /* code... */

    /* dont close db in library */
    /* PQfinish( dbconn ); */
    return( 0 );
}

Hum, the connection is never closed, it should be possible to do it in a
cleaner way...

Any hint?

Thx,
Alex


В списке pgsql-general по дате отправления:

Предыдущее
От: Leif Jensen
Дата:
Сообщение: Re: PHP and PostgreSQL
Следующее
От: "Lars Maschke"
Дата:
Сообщение: [pgsql-performance] Performance Problems