From: | Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com> |
---|---|
To: | james(at)stev(dot)org |
Cc: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: BUG #6413: pg_relation_size wont work on table with upper case chars |
Date: | 2012-01-28 19:33:55 |
Message-ID: | 4F244DA3.30602@enterprisedb.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
On 28.01.2012 18:16, james(at)stev(dot)org wrote:
> I suspect pg_relation_size has a tolower in it to a table name called
> Attempts will not work with pg_relation_size
>
> Both
>
> pg_relation_size('Attempts')
> and
> pg_relation_size('attempts')
>
> fails with no such table.
>
> After table rename from Attempts to attempts it will work.
Try double-quoting the table name, within the single-quotes:
pg_relation_size('"Attempts"').
This is explained in the context of nextval() function at:
http://www.postgresql.org/docs/9.1/static/functions-sequence.html
Looks like the manual page on pg_relation_size(), or "Object Identifier
Types" where the regclass datatype is otherwise explained, don't mention
anything about the double-quoting. Patches to improve that are welcome..
--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com
From | Date | Subject | |
---|---|---|---|
Next Message | James Stevenson | 2012-01-28 20:30:10 | Re: BUG #6413: pg_relation_size wont work on table with upper case chars |
Previous Message | Euler Taveira de Oliveira | 2012-01-28 19:28:06 | Re: BUG #6413: pg_relation_size wont work on table with upper case chars |