Skip site navigation (1) Skip section navigation (2)

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

From: james(at)stev(dot)org
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #6413: pg_relation_size wont work on table with upper case chars
Date: 2012-01-28 16:16:47
Message-ID: E1RrAxL-0007e3-HL@wrigleys.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
The following bug has been logged on the website:

Bug reference:      6413
Logged by:          James Stevenson
Email address:      james(at)stev(dot)org
PostgreSQL version: 8.4.9
Operating system:   Linux - Debian Squeeze
Description:        


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.



Responses

pgsql-bugs by date

Next:From: Euler Taveira de OliveiraDate: 2012-01-28 16:55:46
Subject: Re: BUG #6412: psql & fe-connect truncate passwords
Previous:From: Thomas KellererDate: 2012-01-28 08:44:23
Subject: Documentation bug regarding collations

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group