[pgpool-general: 3817] Re: Bug report response timeline

Pablo Sanchez pablo at blueoakdb.com
Thu Jun 18 01:54:19 JST 2015


Using spaces for object names can be very klunky for a CLI DBA.    All 
references have to be quoted.

Similar for a report writer or anyone else accessing the objects.
---
pablo on my mobile device



On June 17, 2015 12:50:40 PM "Josh Ault" <josh at catalyze.io> wrote:

> My personal preference is to never use spaces. However, as part of my 
> company's product it allows customers to choose "class" names that are 
> descriptive for them and easy to remember. This often times involves 
> spaces. We sanitize the names and use them as part of the table names. 
> Since spaces are not stripped as part of the sanitization process they 
> remain in the table name. I completely agree with you that spaces are very 
> unusual, but still they are allowed in postgres as long as you use double 
> quotes. 
>
>
>
>
> Thanks!
>
> --
>
> Josh
>
> On Wed, Jun 17, 2015 at 11:44 AM, Tatsuo Ishii <ishii at postgresql.org>
> wrote:
>
> > Just out of curiosity, why do you want to use spaces for table names?
> > For me it is pretty unusual.
> > Best regards,
> > --
> > Tatsuo Ishii
> > SRA OSS, Inc. Japan
> > English: http://www.sraoss.co.jp/index_en.php
> > Japanese:http://www.sraoss.co.jp
> >> Hello,
> >>
> >>
> >> I created a bug report here 
> http://www.pgpool.net/mantisbt/view.php?id=136 but no one has been assigned 
> or taken a look at it. Or at least thats what it seems. What is the general 
> timeline for getting these resolved or at least responded to? Also if 
> anyone has thoughts on how to resolve this issue that would be much 
> appreciated. It's been 11 days so far.
> >>
> >>
> >> Essentially pgpool uses to_regclass() but when given a class name with a 
> space, it uses single quotes and the to_regclass function fails. Despite my 
> query using double quotes. More information is in the bug submission.
>
>
> ----------
> _______________________________________________
> pgpool-general mailing list
> pgpool-general at pgpool.net
> http://www.pgpool.net/mailman/listinfo/pgpool-general
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20150617/a9b178d6/attachment-0001.html>


More information about the pgpool-general mailing list