That seems to work. thanks
-----Original Message----- From: Heikki Linnakangas [mailto:heikki.linnakan...@enterprisedb.com] Sent: 28 January 2012 19:34 To: James Stevenson Cc: pgsql-bugs@postgresql.org Subject: Re: [BUGS] BUG #6413: pg_relation_size wont work on table with upper case chars On 28.01.2012 18:16, ja...@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 ----- No virus found in this message. Checked by AVG - www.avg.com Version: 2012.0.1901 / Virus Database: 2109/4763 - Release Date: 01/24/12 -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
