<html>
<head>
</head>
<body>
<div style="color: black;">
<div style="color: black;">
<p style="margin: 0 0 1em 0; color: black;">Using spaces for object names
can be very klunky for a CLI DBA. All references have to
be quoted. </p>
<p style="margin: 0 0 1em 0; color: black;">Similar for a report writer or
anyone else accessing the objects. <br>
---<br>
pablo on my mobile device <br>
</p>
</div>
<div style="color: black;">
<p
style="color: black; font-size: 10pt; font-family: Arial, sans-serif; margin: 10pt 0;">On
June 17, 2015 12:50:40 PM "Josh Ault" <josh@catalyze.io>
wrote:</p>
<blockquote type="cite" class="gmail_quote"
style="margin: 0 0 0 0.75ex; border-left: 1px solid #808080; padding-left: 0.75ex;"><span
id="mailbox-conversation"><div>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. </div>
<div><br></div>
<div>Thanks!</div>
<div>--</div>
<div>Josh</div></span><div class="mailbox_signature"><br></div>
<br><br><div class="gmail_quote"><p>On Wed, Jun 17, 2015 at 11:44 AM,
Tatsuo Ishii <span dir="ltr"><<a href="mailto:ishii@postgresql.org"
target="_blank">ishii@postgresql.org</a>></span>
wrote:<br></p><blockquote class="gmail_quote"
style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;"><p>Just
out of curiosity, why do you want to use spaces for table names?
<br>For me it is pretty unusual.
<br><br>Best regards,
<br>--
<br>Tatsuo Ishii
<br>SRA OSS, Inc. Japan
<br>English: http://www.sraoss.co.jp/index_en.php
<br>Japanese:http://www.sraoss.co.jp
<br><br>> Hello,
<br>>
<br>>
<br>> 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.
<br>>
<br>>
<br>> 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.
<br></p></blockquote></div><br>
_______________________________________________<br>
pgpool-general mailing list<br>
<a class="aqm-autolink aqm-autowrap"
href="mailto:pgpool-general%40pgpool.net">pgpool-general@pgpool.net</a><br>
<a class="aqm-autolink aqm-autowrap"
href="http://www.pgpool.net/mailman/listinfo/pgpool-general">http://www.pgpool.net/mailman/listinfo/pgpool-general</a><br>
<br>
</blockquote>
</div>
</div>
</body>
</html>