Skip site navigation (1) Skip section navigation (2)

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: (view raw, whole thread or download thread mbox)
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

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group