BUG #5023: pg_relation_size() is not case sensitive - Mailing list pgsql-bugs

From Joseph Shraibman
Subject BUG #5023: pg_relation_size() is not case sensitive
Date
Msg-id 200908312203.n7VM33tC072531@wwwmaster.postgresql.org
Whole thread Raw
Responses Re: BUG #5023: pg_relation_size() is not case sensitive  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
List pgsql-bugs
The following bug has been logged online:

Bug reference:      5023
Logged by:          Joseph Shraibman
Email address:      jks@selectacast.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.

pgsql-bugs by date:

Previous
From: Jaime Casanova
Date:
Subject: lost statistics; analyze needs to execute twice
Next
From: "Kevin Grittner"
Date:
Subject: Re: BUG #5023: pg_relation_size() is not case sensitive