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