Postgres Pro
Downloads
Home   >   mailing lists

BUG #6413: pg_relation_size wont work on table with upper case chars - Mailing list pgsql-bugs

From james@stev.org
Subject BUG #6413: pg_relation_size wont work on table with upper case chars
Date
Msg-id E1RrAxL-0007e3-HL@wrigleys.postgresql.org
Whole thread Raw
Responses Re: BUG #6413: pg_relation_size wont work on table with upper case chars  (Euler Taveira de Oliveira <euler@timbira.com>)
Re: BUG #6413: pg_relation_size wont work on table with upper case chars  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
List pgsql-bugs
Tree view 
The following bug has been logged on the website:

Bug reference:      6413
Logged by:          James Stevenson
Email address:      james@stev.org
PostgreSQL version: 8.4.9
Operating system:   Linux - Debian Squeeze
Description:=20=20=20=20=20=20=20=20


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.

pgsql-bugs by date:

Previous
From: Euler Taveira de Oliveira
Date:
Subject: Re: BUG #6412: psql & fe-connect truncate passwords
Next
From: Andy Grimm
Date:
Subject: Re: BUG #6412: psql & fe-connect truncate passwords