Re: [Bacula-devel] PostgreSQL quoting

2007-09-05 Thread Dan Langille
On 5 Sep 2007 at 18:47, Kern Sibbald wrote: > On Wednesday 05 September 2007 18:03, Dan Langille wrote: > > On 5 Sep 2007 at 0:00, Kern Sibbald wrote: > > > On Tuesday 04 September 2007 19:42, Dan Langille wrote: > > > > On 3 Sep 2007 at 13:35, Martin Simmons wrote: > > > > > > On Sat, 01 Sep

Re: [Bacula-devel] PostgreSQL quoting

2007-09-05 Thread Kern Sibbald
On Wednesday 05 September 2007 18:03, Dan Langille wrote: > On 5 Sep 2007 at 0:00, Kern Sibbald wrote: > > On Tuesday 04 September 2007 19:42, Dan Langille wrote: > > > On 3 Sep 2007 at 13:35, Martin Simmons wrote: > > > > > On Sat, 01 Sep 2007 11:44:03 +0200, Marc Cousin said: > > > > > > > >

Re: [Bacula-devel] PostgreSQL quoting

2007-09-05 Thread Dan Langille
On 5 Sep 2007 at 0:00, Kern Sibbald wrote: > On Tuesday 04 September 2007 19:42, Dan Langille wrote: > > On 3 Sep 2007 at 13:35, Martin Simmons wrote: > > > > On Sat, 01 Sep 2007 11:44:03 +0200, Marc Cousin said: > > > > > > > > I think you're trying to solve a fake problem here : > > > > PQes

Re: [Bacula-devel] PostgreSQL quoting

2007-09-04 Thread Kern Sibbald
On Tuesday 04 September 2007 19:42, Dan Langille wrote: > On 3 Sep 2007 at 13:35, Martin Simmons wrote: > > > On Sat, 01 Sep 2007 11:44:03 +0200, Marc Cousin said: > > > > > > I think you're trying to solve a fake problem here : > > > PQescapeStringConn does the job as required, there is no pro

Re: [Bacula-devel] PostgreSQL quoting

2007-09-04 Thread Dan Langille
On 4 Sep 2007 at 17:11, Bill Moran wrote: > In response to "Dan Langille" <[EMAIL PROTECTED]>: > > > On 4 Sep 2007 at 16:26, Bill Moran wrote: > > > > > In response to "Dan Langille" <[EMAIL PROTECTED]>: > > > > > > [snip] > > > > > > > > > > > > > > You may be correct, except that it's not the

Re: [Bacula-devel] PostgreSQL quoting

2007-09-04 Thread Bill Moran
In response to "Dan Langille" <[EMAIL PROTECTED]>: > On 4 Sep 2007 at 16:26, Bill Moran wrote: > > > In response to "Dan Langille" <[EMAIL PROTECTED]>: > > > > [snip] > > > > > > > > > > > > You may be correct, except that it's not the "whole" point. From > > > > > > the > > > > > > docs, it c

Re: [Bacula-devel] PostgreSQL quoting

2007-09-04 Thread Dan Langille
On 4 Sep 2007 at 16:26, Bill Moran wrote: > In response to "Dan Langille" <[EMAIL PROTECTED]>: > > [snip] > > > > > > > > > > You may be correct, except that it's not the "whole" point. From the > > > > > docs, it can "adjust its behavior depending on the connection > > > > > properties > > > >

Re: [Bacula-devel] PostgreSQL quoting

2007-09-04 Thread Bill Moran
In response to "Dan Langille" <[EMAIL PROTECTED]>: [snip] > > > > > > > > You may be correct, except that it's not the "whole" point. From the > > > > docs, it can "adjust its behavior depending on the connection properties > > > > (such as character encoding)" > > > > > > > > Whether or not thos

Re: [Bacula-devel] PostgreSQL quoting

2007-09-04 Thread Dan Langille
Resending, with typo corrections and addition of a URL On 4 Sep 2007 at 15:45, Bill Moran wrote: > In response to Marc Cousin <[EMAIL PROTECTED]>: > > > On Tuesday 04 September 2007 21:10:34 Bill Moran wrote: > > > In response to Marc Cousin <[EMAIL PROTECTED]>: > > > > On Tuesday 04 September 2

Re: [Bacula-devel] PostgreSQL quoting

2007-09-04 Thread Dan Langille
On 4 Sep 2007 at 15:45, Bill Moran wrote: > In response to Marc Cousin <[EMAIL PROTECTED]>: > > > On Tuesday 04 September 2007 21:10:34 Bill Moran wrote: > > > In response to Marc Cousin <[EMAIL PROTECTED]>: > > > > On Tuesday 04 September 2007 20:08:08 Bill Moran wrote: > > > > > In response to

Re: [Bacula-devel] PostgreSQL quoting

2007-09-04 Thread Bill Moran
In response to Marc Cousin <[EMAIL PROTECTED]>: > On Tuesday 04 September 2007 21:10:34 Bill Moran wrote: > > In response to Marc Cousin <[EMAIL PROTECTED]>: > > > On Tuesday 04 September 2007 20:08:08 Bill Moran wrote: > > > > In response to "Dan Langille" <[EMAIL PROTECTED]>: > > > > > On 3 Sep

Re: [Bacula-devel] PostgreSQL quoting

2007-09-04 Thread Marc Cousin
On Tuesday 04 September 2007 21:10:34 Bill Moran wrote: > In response to Marc Cousin <[EMAIL PROTECTED]>: > > On Tuesday 04 September 2007 20:08:08 Bill Moran wrote: > > > In response to "Dan Langille" <[EMAIL PROTECTED]>: > > > > On 3 Sep 2007 at 13:35, Martin Simmons wrote: > > > > > > On Sat

Re: [Bacula-devel] PostgreSQL quoting

2007-09-04 Thread Bill Moran
In response to Marc Cousin <[EMAIL PROTECTED]>: > On Tuesday 04 September 2007 20:08:08 Bill Moran wrote: > > In response to "Dan Langille" <[EMAIL PROTECTED]>: > > > On 3 Sep 2007 at 13:35, Martin Simmons wrote: > > > > > On Sat, 01 Sep 2007 11:44:03 +0200, Marc Cousin said: > > > > > > > > >

Re: [Bacula-devel] PostgreSQL quoting

2007-09-04 Thread Marc Cousin
On Tuesday 04 September 2007 20:08:08 Bill Moran wrote: > In response to "Dan Langille" <[EMAIL PROTECTED]>: > > On 3 Sep 2007 at 13:35, Martin Simmons wrote: > > > > On Sat, 01 Sep 2007 11:44:03 +0200, Marc Cousin said: > > > > > > > > I think you're trying to solve a fake problem here : > > >

Re: [Bacula-devel] PostgreSQL quoting

2007-09-04 Thread Martin Simmons
> On Tue, 4 Sep 2007 14:08:08 -0400, Bill Moran said: > > In response to "Dan Langille" <[EMAIL PROTECTED]>: > > > On 3 Sep 2007 at 13:35, Martin Simmons wrote: > > > > > > On Sat, 01 Sep 2007 11:44:03 +0200, Marc Cousin said: > > > > > > > > I think you're trying to solve a fake proble

Re: [Bacula-devel] PostgreSQL quoting

2007-09-04 Thread Bill Moran
In response to "Dan Langille" <[EMAIL PROTECTED]>: > On 3 Sep 2007 at 13:35, Martin Simmons wrote: > > > > On Sat, 01 Sep 2007 11:44:03 +0200, Marc Cousin said: > > > > > > I think you're trying to solve a fake problem here : > > > PQescapeStringConn does the job as required, there is no pro

Re: [Bacula-devel] PostgreSQL quoting

2007-09-04 Thread Dan Langille
On 3 Sep 2007 at 13:35, Martin Simmons wrote: > > On Sat, 01 Sep 2007 11:44:03 +0200, Marc Cousin said: > > > > I think you're trying to solve a fake problem here : > > PQescapeStringConn does the job as required, there is no problem except a > > warning. As I understand it, the warning is

Re: [Bacula-devel] PostgreSQL quoting

2007-09-03 Thread Cousin Marc
> I didn't realized that there were was to suppress the warning messages > other than using the E`...` syntax. I suspect that enabling > standard_conforming_strings is the way to go ... > > Thanks :-) > > Regards, > > Kern It is the way to go, as it will be the 'standard' way of doing things in a

Re: [Bacula-devel] PostgreSQL quoting

2007-09-03 Thread Martin Simmons
> On Sat, 01 Sep 2007 11:44:03 +0200, Marc Cousin said: > > I think you're trying to solve a fake problem here : > PQescapeStringConn does the job as required, there is no problem except a > warning. > > The reason for this is the following : > You're asking postgresql to : > - Use non-stand

Re: [Bacula-devel] PostgreSQL quoting

2007-09-02 Thread Kern Sibbald
On Saturday 01 September 2007 11:44, Marc Cousin wrote: > I think you're trying to solve a fake problem here : > PQescapeStringConn does the job as required, there is no problem except a > warning. > > The reason for this is the following : > You're asking postgresql to : > - Use non-standard confo

Re: [Bacula-devel] PostgreSQL quoting

2007-09-01 Thread Marc Cousin
I think you're trying to solve a fake problem here : PQescapeStringConn does the job as required, there is no problem except a warning. The reason for this is the following : You're asking postgresql to : - Use non-standard conforming strings (aka old postgresql way of doing things) - Do a conver

Re: [Bacula-devel] PostgreSQL quoting

2007-08-31 Thread Kern Sibbald
On Friday 31 August 2007 14:03, Martin Simmons wrote: > > On Thu, 30 Aug 2007 23:30:37 +0200, Kern Sibbald said: > > > > On Thursday 30 August 2007 22:12, Martin Simmons wrote: > > > > On Thu, 30 Aug 2007 14:57:27 -0400, Dan Langille said: > > > > > > > > It seems that PQescapeStringConn is

Re: [Bacula-devel] PostgreSQL quoting

2007-08-31 Thread Martin Simmons
> On Thu, 30 Aug 2007 23:30:37 +0200, Kern Sibbald said: > > On Thursday 30 August 2007 22:12, Martin Simmons wrote: > > > On Thu, 30 Aug 2007 14:57:27 -0400, Dan Langille said: > > > > > > It seems that PQescapeStringConn is insufficient to avoid the warning > > > "WARNING: nonstandard u

Re: [Bacula-devel] PostgreSQL quoting

2007-08-30 Thread Bill Moran
In response to Kern Sibbald <[EMAIL PROTECTED]>: > On Thursday 30 August 2007 22:12, Martin Simmons wrote: > > > On Thu, 30 Aug 2007 14:57:27 -0400, Dan Langille said: > > > > > > It seems that PQescapeStringConn is insufficient to avoid the warning > > > "WARNING: nonstandard use of escape i

Re: [Bacula-devel] PostgreSQL quoting

2007-08-30 Thread Kern Sibbald
On Thursday 30 August 2007 22:12, Martin Simmons wrote: > > On Thu, 30 Aug 2007 14:57:27 -0400, Dan Langille said: > > > > It seems that PQescapeStringConn is insufficient to avoid the warning > > "WARNING: nonstandard use of escape in a string literal". I'm > > running the regression tests.

Re: [Bacula-devel] PostgreSQL quoting

2007-08-30 Thread Martin Simmons
> On Thu, 30 Aug 2007 14:57:27 -0400, Dan Langille said: > > It seems that PQescapeStringConn is insufficient to avoid the warning > "WARNING: nonstandard use of escape in a string literal". I'm > running the regression tests. > > a-file-with-a-slash\-in-itlocalhost-dir > becomes > a-fil

[Bacula-devel] PostgreSQL quoting

2007-08-30 Thread Dan Langille
It seems that PQescapeStringConn is insufficient to avoid the warning "WARNING: nonstandard use of escape in a string literal". I'm running the regression tests. a-file-with-a-slash\-in-itlocalhost-dir becomes a-file-with-a-slash\\-in-itlocalhost-dir regress=# SELECT FilenameId FROM Filename