Обсуждение: BUG #6413: pg_relation_size wont work on table with upper case chars

The following bug has been logged on the website:

Bug reference:      6413
Logged by:          James Stevenson
Email address:      james@stev.org
PostgreSQL version: 8.4.9
Operating system:   Linux - Debian Squeeze
Description:=20=20=20=20=20=20=20=20


I suspect pg_relation_size has a tolower in it to a table name called
Attempts will not work with pg_relation_size

Both

pg_relation_size('Attempts')
and
pg_relation_size('attempts')

fails with no such table.

After table rename from Attempts to attempts it will work.

On 28-01-2012 13:16, james@stev.org wrote:
> pg_relation_size('Attempts')
> and
> pg_relation_size('attempts')
>
pg_relation_size('"Attempts"')


--
   Euler Taveira de Oliveira - Timbira       http://www.timbira.com.br/
   PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento

On 28.01.2012 18:16, james@stev.org wrote:
> I suspect pg_relation_size has a tolower in it to a table name called
> Attempts will not work with pg_relation_size
>
> Both
>
> pg_relation_size('Attempts')
> and
> pg_relation_size('attempts')
>
> fails with no such table.
>
> After table rename from Attempts to attempts it will work.

Try double-quoting the table name, within the single-quotes:
pg_relation_size('"Attempts"').

This is explained in the context of nextval() function at:

http://www.postgresql.org/docs/9.1/static/functions-sequence.html

Looks like the manual page on pg_relation_size(), or "Object Identifier
Types" where the regclass datatype is otherwise explained, don't mention
anything about the double-quoting. Patches to improve that are welcome..

--
   Heikki Linnakangas
   EnterpriseDB   http://www.enterprisedb.com

VGhhdCBzZWVtcyB0byB3b3JrLg0KDQp0aGFua3MNCg0KLS0tLS1PcmlnaW5h
bCBNZXNzYWdlLS0tLS0NCkZyb206IEhlaWtraSBMaW5uYWthbmdhcyBbbWFp
bHRvOmhlaWtraS5saW5uYWthbmdhc0BlbnRlcnByaXNlZGIuY29tXSANClNl
bnQ6IDI4IEphbnVhcnkgMjAxMiAxOTozNA0KVG86IEphbWVzIFN0ZXZlbnNv
bg0KQ2M6IHBnc3FsLWJ1Z3NAcG9zdGdyZXNxbC5vcmcNClN1YmplY3Q6IFJl
OiBbQlVHU10gQlVHICM2NDEzOiBwZ19yZWxhdGlvbl9zaXplIHdvbnQgd29y
ayBvbiB0YWJsZSB3aXRoIHVwcGVyIGNhc2UgY2hhcnMNCg0KT24gMjguMDEu
MjAxMiAxODoxNiwgamFtZXNAc3Rldi5vcmcgd3JvdGU6DQo+IEkgc3VzcGVj
dCBwZ19yZWxhdGlvbl9zaXplIGhhcyBhIHRvbG93ZXIgaW4gaXQgdG8gYSB0
YWJsZSBuYW1lIGNhbGxlZA0KPiBBdHRlbXB0cyB3aWxsIG5vdCB3b3JrIHdp
dGggcGdfcmVsYXRpb25fc2l6ZQ0KPg0KPiBCb3RoDQo+DQo+IHBnX3JlbGF0
aW9uX3NpemUoJ0F0dGVtcHRzJykNCj4gYW5kDQo+IHBnX3JlbGF0aW9uX3Np
emUoJ2F0dGVtcHRzJykNCj4NCj4gZmFpbHMgd2l0aCBubyBzdWNoIHRhYmxl
Lg0KPg0KPiBBZnRlciB0YWJsZSByZW5hbWUgZnJvbSBBdHRlbXB0cyB0byBh
dHRlbXB0cyBpdCB3aWxsIHdvcmsuDQoNClRyeSBkb3VibGUtcXVvdGluZyB0
aGUgdGFibGUgbmFtZSwgd2l0aGluIHRoZSBzaW5nbGUtcXVvdGVzOiANCnBn
X3JlbGF0aW9uX3NpemUoJyJBdHRlbXB0cyInKS4NCg0KVGhpcyBpcyBleHBs
YWluZWQgaW4gdGhlIGNvbnRleHQgb2YgbmV4dHZhbCgpIGZ1bmN0aW9uIGF0
Og0KDQpodHRwOi8vd3d3LnBvc3RncmVzcWwub3JnL2RvY3MvOS4xL3N0YXRp
Yy9mdW5jdGlvbnMtc2VxdWVuY2UuaHRtbA0KDQpMb29rcyBsaWtlIHRoZSBt
YW51YWwgcGFnZSBvbiBwZ19yZWxhdGlvbl9zaXplKCksIG9yICJPYmplY3Qg
SWRlbnRpZmllciANClR5cGVzIiB3aGVyZSB0aGUgcmVnY2xhc3MgZGF0YXR5
cGUgaXMgb3RoZXJ3aXNlIGV4cGxhaW5lZCwgZG9uJ3QgbWVudGlvbiANCmFu
eXRoaW5nIGFib3V0IHRoZSBkb3VibGUtcXVvdGluZy4gUGF0Y2hlcyB0byBp
bXByb3ZlIHRoYXQgYXJlIHdlbGNvbWUuLg0KDQotLSANCiAgIEhlaWtraSBM
aW5uYWthbmdhcw0KICAgRW50ZXJwcmlzZURCICAgaHR0cDovL3d3dy5lbnRl
cnByaXNlZGIuY29tDQoNCi0tLS0tDQpObyB2aXJ1cyBmb3VuZCBpbiB0aGlz
IG1lc3NhZ2UuDQpDaGVja2VkIGJ5IEFWRyAtIHd3dy5hdmcuY29tDQpWZXJz
aW9uOiAyMDEyLjAuMTkwMSAvIFZpcnVzIERhdGFiYXNlOiAyMTA5LzQ3NjMg
LSBSZWxlYXNlIERhdGU6IDAxLzI0LzEyDQo=