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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-bugs by date

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