| From: | Emmanuel Cecchet <manu(at)asterdata(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Emmanuel Cecchet <manu(at)asterdata(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Regclass and quoted table names |
| Date: | 2009-03-04 12:34:09 |
| Message-ID: | 49AE7541.1030700@asterdata.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Tom Lane wrote:
> Emmanuel Cecchet <manu(at)asterdata(dot)com> writes:
>
>> It looks like the behavior of regclass is not consistent when table
>> names are quoted. The name is returned without the quotes if the name is
>> lower case with eventual trailing numbers, otherwise it is returned with
>> quotes.
>>
>
> It's intentional that it quotes only when needed.
>
This is problematic in situations where the output of the cast is involved in some later join which returns incorrect results because of the extra double quotes surrounding the table name.
Is there a way to override the default behavior to have a consistent quoted or non-quoted result?
Thanks,
Emmanuel
--
Emmanuel Cecchet
Aster Data Systems
Web: http://www.asterdata.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Greg Stark | 2009-03-04 12:41:41 | Re: Regclass and quoted table names |
| Previous Message | Heikki Linnakangas | 2009-03-04 11:01:34 | Re: Immediate shutdown and system(3) |