Search Postgresql Archives

Re: contrib/dbsize

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Can I take the new .c file, do a make install, and have it work in 7.4.7 ?

Michael Fuhr wrote:
On Tue, Apr 05, 2005 at 01:25:01PM -0400, Joseph Shraibman wrote:

local]:o=>select version();
version
---------------------------------------------------------------------------------------------------------
PostgreSQL 7.4.7 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.2.2 20030222 (Red Hat Linux 3.2.2-5)
(1 row)


[local]:o=>select  relation_size('pg_am_oid_index');
ERROR:  "pg_am_oid_index" is an index


Looks like this has been fixed in PostgreSQL 8.x.

http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/dbsize/dbsize.c

test=> SELECT version();
version --------------------------------------------------------------------------------
PostgreSQL 8.0.2beta1 on sparc-sun-solaris2.9, compiled by GCC gcc (GCC) 3.4.2
(1 row)


test=> SELECT relation_size('pg_am_oid_index');
relation_size ---------------
16384
(1 row)



---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your message can get through to the mailing list cleanly

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux