Re: [BUGS] BUG #6413: pg_relation_size wont work on table with uppercase chars

#1

On 28-01-2012 13:16, james (AT) stev (DOT) org wrote:

Quote:

pg_relation_size('Attempts')
and
pg_relation_size('attempts')

pg_relation_size('"Attempts"')

--
Euler Taveira de Oliveira - Timbira http://www.timbira.com.br/
PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento

--
Sent via pgsql-bugs mailing list (pgsql-bugs (AT) postgresql (DOT) org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

#2

On 28.01.2012 18:16, james (AT) stev (DOT) org wrote:

Quote:

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/s...-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

--
Sent via pgsql-bugs mailing list (pgsql-bugs (AT) postgresql (DOT) org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: [BUGS] BUG #6413: pg_relation_size wont work on table with uppercase chars

mailing.database.pgsql-bugs mailing.database.pgsql-bugs

Re: [BUGS] BUG #6413: pg_relation_size wont work on table with uppercase chars - 01-28-2012 , 01:28 PM

Re: [BUGS] BUG #6413: pg_relation_size wont work on table with uppercase chars - 01-28-2012 , 01:33 PM