BUG #12784: pg_relation_size has problems with case in index name - Mailing list pgsql-bugs

From gibheer@zero-knowledge.org
Subject BUG #12784: pg_relation_size has problems with case in index name
Date
Msg-id 20150218192712.8729.67799@wrigleys.postgresql.org
Whole thread Raw
Responses Re: BUG #12784: pg_relation_size has problems with case in index name
Re: BUG #12784: pg_relation_size has problems with case in index name
List pgsql-bugs
The following bug has been logged on the website:

Bug reference:      12784
Logged by:          Stefan Radomski
Email address:      gibheer@zero-knowledge.org
PostgreSQL version: 9.4.1
Operating system:   FreeBSD 10.1p5
Description:

I found a problem with indexes which have an uppercase letter in the name.
You can reproduce it with the following statements:

  create table unfindable("Test" text);
  create index on unfindable("Test");
  \d unfindable
  select pg_relation_size('unfindable_Test_idx');

It does work for tables with upper case characters in the name though.

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #12782: Some abnormal observation about the to_date() function in greenplum database
Next
From: David G Johnston
Date:
Subject: Re: BUG #12784: pg_relation_size has problems with case in index name