On Sun, Jan 2, 2011 at 15:07, Peter Eisentraut <peter_e(at)gmx(dot)net> wrote:
> On tis, 2010-12-28 at 13:13 +0100, Magnus Hagander wrote:
>> My pg_streamrecv no longer works with 9.1, because it returns
>> PGRES_COPY_BOTH instead of PGRES_COPY_OUT when initating a copy.
>> That's fine.
>> So I'd like to make it work on both. Specifically, I would like it to
>> check for PGRES_COPY_BOTH if the server is 9.1 and PGRES_COPY_OUT if
>> it's 9.0. Which can be done by checking the server version.
> ISTM that the correct fix is to increment to protocol version number to
> 3.1 and send PGRES_COPY_OUT if the client requests version 3.0. That's
> what the version numbers are for, no?
In a way - yes. I assume we didn't do that because it's considered "internal".
It still won't help in my situation though - I need to know what
version of the libpq headers I have in order to even be able to
*compile* the program. At runtime, I could check against the server
version, and get around it.
That said, if we are going to incorporate pg_streamrecv in the backend
for 9.1, *my* problem goes away, as does the problem directly related
to the change of PGRES_COPY_OUT. But the basic principle of the
problem still remains...
In response to
pgsql-hackers by date
|Next:||From: Dmitry Koterov||Date: 2011-01-03 12:11:33|
|Subject: Re: pg_dump --split patch|
|Previous:||From: Brar Piening||Date: 2011-01-03 11:26:30|
|Subject: Re: Visual Studio 2010/Windows SDK 7.1 support|