Greg Smith <greg@xxxxxxxxxxxxxxx> writes: > Tom Lane wrote: >> We could prevent your query from failing if we did something like having >> pg_relation_size() return NULL, rather than throwing an error, if the >> OID it's given doesn't turn out to correspond to a live table. I'm not >> sure if that'd be a net improvement or not --- it certainly seems to >> reduce the system's ability to detect simple errors > I've struggled with scripts using pg_relation_size doing strange things > because of this more than once. How about a) return NULL and b) log at > NOTICE that you just asked for something undefined? I don't care for the NOTICE at all; it's just useless log bloat (that likely will never be seen by a human) in most use-cases. Either we think this is an expected case, or not. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
