DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com;
	h=received:message-id:date:from:reply-to:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references;
	b=BM0GSiBS37fCFL5Hit09jovFpKlWzbC/KIYijpL0cUwrBvZKHqzd/1ukmNiJUbt2bpSjzbSJBVjn5HOVbNe0o9p2lVEnHzhMbM/skLLMQuvWgHmTrRyMG0z/Ul80of+gzTimO7fBCyKWNBgB5r2rLx228V5oVtjIr2DIkiRkVQM=
Message-ID: <2b5c484b05052006206c301de@mail.gmail.com>
Date: Fri, 20 May 2005 14:20:58 +0100
From: Gustavo Lopes <contratempo@gmail.com>
Reply-To: Gustavo Lopes <contratempo@gmail.com>
To: pgsql-interfaces@postgresql.org
Subject: Re: libpq on windows
In-Reply-To: <20704.202.47.227.25.1116570741.squirrel@202.47.227.25>
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
References: <2b5c484b05051906526f8bb577@mail.gmail.com>
	<20704.202.47.227.25.1116570741.squirrel@202.47.227.25>

No, I'd say the notice processor/receiver is not the problem since
I've been able to implement a notice receiver that would display the
received notices without any complications.
The problem seems to arise only when a message contains a HINT
attached (I don't even know whether messages of type NOTICE can
cointain a hint field, but anyway that doesn't seem relevant to this
issue).

Gustavio Lopes

On 20/05/05, jtv@xs4all.nl <jtv@xs4all.nl> wrote:
> Gustavo Lopes <contratempo@gmail.com> wrote:
>=20
> > The problem seems to occurr only when the server sends a hint or the
> > dll generates one. This can happen when the connection to the server
> > cannot be established because the server is not running, a nonexistant
> > postgres function exist is called, when one attempts to drop an index
> > upon which a constraint depends, etc. (the program doesn't go beyond
> > PQconnectdb, PQexec or PQexecparam). Since my debugging skills are
> > very poor I cannot give any accurate description on what is causing
> > the exception.
> > The problem can be very easily reproduced by creating a C program
> > which calls PQconnectdb with a host parameter that points to a machine
> > that is not running postgres.
> > Running the same program under linux (although I used older versions
> > of the interface and the server) does not cause any problems.
>=20
> It could be the notice processor that crashes.  A "notice processor" is a
> callback that you can register with libpq that handles error messages.
> The default is to print them to the console, but I'm not sure you can
> always do that in a Windows program.  Or since you're apparently using
> different compilers for libpq and the application, maybe the default
> notice processor gets linked to a different standard library than it
> expects and fails because of that.
>=20
> Notice processors are documented here:
>=20
> http://www.postgresql.org/docs/8.0/interactive/libpq-notice-processing.ht=
ml
>=20
> To find out if this is what's wrong, try creating an empty function (with
> C-style calling convention, not a regular C++ function) and setting that
> as the notice processor:
>=20
>   extern "C" { /* (this line only needed in C++) */
>   void emptynoticeprocessor(void *, const char *)
>   {
>   }
>   } /* (this line only needed in C++) */
>=20
> Now in your code, just after you opened your connection (call it "c"):
>=20
>   PQsetNoticeProcessor(c,emptynoticeprocessor,NULL);
>=20
> Of course that will mean that error messages are not displayed, so if thi=
s
> solves your crashing problem then your next step is to implement somethin=
g
> here that displays the given message!
>=20
> Jeroen
>=20
>