Thread: 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.
Re: BUG #6413: pg_relation_size wont work on table with upper case chars
From
Euler Taveira de Oliveira
Date:
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
Re: BUG #6413: pg_relation_size wont work on table with upper case chars
From
Heikki Linnakangas
Date:
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
Re: BUG #6413: pg_relation_size wont work on table with upper case chars
From
"James Stevenson"
Date:
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=