Re: pgAgent Database Name Limitation

On Tue, Sep 4, 2012 at 12:00 PM, Martin French
<Martin.French@romaxtech.com> wrote:
>
>> > connInfo connInfo::getConnectionInfo(wxString connStr)
>> > {
>> >         connInfo cnInfo;
>> >
>> >         wxRegEx propertyExp;
>> >
>> >         // Remove the white-space(s) to match the following format
>> >         // i.e. prop=value
>> >         bool res = propertyExp.Compile(wxT("(([ ]*[\t]*)+)="));
>> >
>> >         propertyExp.ReplaceAll(&connStr, wxT("="));
>> >
>> >         res = propertyExp.Compile(wxT("=(([ ]*[\t]*)+)"));
>> >         propertyExp.ReplaceAll(&connStr, wxT("="));
>> >
>> >                // Seperate all the prop=value patterns
>
>> >                wxArrayString tokens = wxStringTokenize(connStr, wxT("\t
>> > \n\r"));
>
>
>> > [...]
>
>
>>
>> The correct fix would be to modify the regexp so it doesn't strip
>> spaces inside of quoted sub-strings. Not sure my regexp-fu is that
>> strong though, so please feel free to work on it :-)
>>
>
>
>
> There's a couple of things going on here Dave that I can't seem to get
> around at the moment. The wxStringTokenize actually destroys the string, so
> I'm going to do a little work here to see if i can fix and allow libpq style
> string quoting! (my regexp-fu is appalling to say the least! ;-) )
>
> Wish me luck...

Good luck :-). Feel free to post here if you need advice; we'll help
out if we can.

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

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