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
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs