Re: BUG #6413: pg_relation_size wont work on table with upper case chars

That seems to work.

thanks

-----Original Message-----
From: Heikki Linnakangas [mailto:heikki(dot)linnakangas(at)enterprisedb(dot)com]
Sent: 28 January 2012 19:34
To: James Stevenson
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: [BUGS] BUG #6413: pg_relation_size wont work on table with upper case chars

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

-----
No virus found in this message.
Checked by AVG - www.avg.com
Version: 2012.0.1901 / Virus Database: 2109/4763 - Release Date: 01/24/12