BUG #5023: pg_relation_size() is not case sensitive

From: "Joseph Shraibman" <jks(at)selectacast(dot)net>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #5023: pg_relation_size() is not case sensitive
Date: 2009-08-31 22:03:03
Message-ID: 200908312203.n7VM33tC072531@wwwmaster.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 5023
Logged by: Joseph Shraibman
Email address: jks(at)selectacast(dot)net
PostgreSQL version: 8.3.7
Operating system: Linux
Description: pg_relation_size() is not case sensitive
Details:

The pg_relation_size(text) method cannot determine the size of a relation
that has capital letters. This became an issue for me because some of
Slony's indexes use capital letters.

The workaround is to use the version of the function that takes an oid.

This issue exists in 8.3.7 and 8.2.13.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Kevin Grittner 2009-08-31 22:11:26 Re: BUG #5023: pg_relation_size() is not case sensitive
Previous Message Jaime Casanova 2009-08-31 22:02:27 lost statistics; analyze needs to execute twice