Re: pulling libpqtypes from queue - Mailing list pgsql-hackers

From Tom Lane
Subject Re: pulling libpqtypes from queue
Date
Msg-id 1333.1208284755@sss.pgh.pa.us
Whole thread Raw
In response to Re: pulling libpqtypes from queue  (Andrew Chernow <ac@esilo.com>)
Responses Re: pulling libpqtypes from queue  (Andrew Chernow <ac@esilo.com>)
List pgsql-hackers
Andrew Chernow <ac@esilo.com> writes:
> Installing it per-conn doesn't get you anything.  pqtypes has already 
> been linked in.  If you use PQexec and PQgetvalue, the pqtypes code 
> pretty much does nothing.  So, a per-conn install seems redundant.  You 
> are installing the same function pointers under the same name over and 
> over.  If you link with, it should just be available.

I don't really agree with that argument; it's not impossible that you'd
want it on some connections and not others.  The server version for
instance could affect the choice.

Per-conn install also gets you out of a bunch of thread safety issues
(because we've already decreed that it's the app's problem to ensure
that only one thread touches a PGconn at a time).
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Re: [COMMITTERS] pgsql: Add pg_terminate_backend() to allow terminating only a single
Next
From: Andrew Chernow
Date:
Subject: Re: pulling libpqtypes from queue