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

[Josh Ault]

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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20150617/08e41e1e/attachment.html>