Re: libpq messages language - Mailing list pgsql-general

From Albe Laurenz
Subject Re: libpq messages language
Date
Msg-id D960CB61B694CF459DCFB4B0128514C2A7D195@exadv11.host.magwien.gv.at
Whole thread Raw
In response to Re: libpq messages language  (Efraín López <tecnomaya@cabsagt.com>)
List pgsql-general
Efraín López wrote:
>>> I am using Windows, and pg 8.2.5
>>>
>>> When making a connection with libpq, if it fails I would like
>>> to get the errors messages in spanish (PQerrorMessage  )
>>>
>>> Is this possible? How can this be done?

I got it to work with this program:

#include <stdlib.h>
#include <stdio.h>
#include <locale.h>
#include <libpq-fe.h>

int main(int argc, char **argv) {
        PGconn *conn;

        setlocale(LC_ALL, "");
        putenv("PGLOCALEDIR=C:\\Programme\\postgres\\share\\locale");

        conn = PQconnectdb("port=4711");
        if (CONNECTION_OK != PQstatus(conn)) {
                fprintf(stderr, "%s\n", PQerrorMessage(conn));
                PQfinish(conn);
                return 1;
        }

        PQfinish(conn);
        return 0;
}

Instead of setting PGLOCALEDIR in the code, you can also define
it as environment variable on your system, that is maybe better.

It must point to the directory where your message files are installed
(you have spanish message files installed, haven't you?).

The above program assumes that there is no database running
on port 4711, so you get an error message from libpq.

Yours,
Laurenz Albe

pgsql-general by date:

Previous
From: Henrik
Date:
Subject: Re: Nested loop in simple query taking long time
Next
From: Henrik
Date:
Subject: Re: Nested loop in simple query taking long time