Re: Regclass and quoted table names

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Emmanuel Cecchet <manu(at)asterdata(dot)com>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Regclass and quoted table names
Date: 2009-03-04 03:10:21
Message-ID: 21713.1236136221@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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.

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2009-03-04 03:15:39 Re: Make SIGHUP less painful if pg_hba.conf is not readable
Previous Message Emmanuel Cecchet 2009-03-04 02:47:23 Regclass and quoted table names