Re: Fix for a problem with auto reconnection - Mailing list pgadmin-hackers

From Dave Page
Subject Re: Fix for a problem with auto reconnection
Date
Msg-id CA+OCxoyPwXBa9AqtH6kbh3B=4KWpdXB9y+STzkiCggo0jHCNdQ@mail.gmail.com
Whole thread Raw
In response to Re: Fix for a problem with auto reconnection  (Christoph Zwerschke <cito@online.de>)
List pgadmin-hackers
On Fri, Jun 27, 2014 at 9:58 AM, Christoph Zwerschke <cito@online.de> wrote:
> Am 27.06.2014 09:57, schrieb Dave Page:
>
>> Ashesh - your thoughts on this? I'm not sure I see how resetting
>> needColQuoting would prevent a datlastsysoid error, though I admit I
>> haven't had a chance to dive into the code yet.
>
>
> Some more detail:
>
> The error happens in line 285 of pgadmin/db/pgConn.cpp:
>
>     if (set->ColNumber(wxT("\"datlastsysoid\"")) >= 0)
>         needColQuoting = true;
>
> This assumes that needColQuoting was set to false before. Another solution
> might be to modify that check to something like this:
>
>     if (!needColQuoting &&
>             set->ColNumber(wxT("\"datlastsysoid\"")) >= 0)
>         needColQuoting = true;

Huh, that a kinda weird way of doing things. I think in the longer
term we should consider refactoring the handling of that variable
entirely.

In any case, I've committed a fix now, doing what your first suggested
(we do that elsewhere it seems).

Thanks!

--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


pgadmin-hackers by date:

Previous
From: Dave Page
Date:
Subject: pgAdmin III commit: Ensure that needColQuoting is reset to false when r
Next
From: "J.F. Oster"
Date:
Subject: PATCH: wxLogInfo() in wxWidgets 3.0