postgresql.git - This is the main PostgreSQL git repository.

Age	Commit message (Collapse)	Author
2005-07-29	Move dbsize functions into the backend. New functions:	Bruce Momjian
	pg_tablespace_size pg_database_size pg_relation_size pg_complete_relation_size pg_size_pretty Remove /contrib/dbsize. Dave Page
2005-07-04	Arrange for the postmaster (and standalone backends, initdb, etc) to	Tom Lane
	chdir into PGDATA and subsequently use relative paths instead of absolute paths to access all files under PGDATA. This seems to give a small performance improvement, and it should make the system more robust against naive DBAs doing things like moving a database directory that has a live postmaster in it. Per recent discussion.
2005-06-19	Simplify uses of readdir() by creating a function ReadDir() that	Tom Lane
	includes error checking and an appropriate ereport(ERROR) message. This gets rid of rather tedious and error-prone manipulation of errno, as well as a Windows-specific bug workaround, at more than a dozen call sites. After an idea in a recent patch by Heikki Linnakangas.
2005-05-27	Remove second argument from textToQualifiedNameList(), as it is no longer	Neil Conway
	used. From Jaime Casanova.
2005-01-01	Update copyrights that were missed.	Bruce Momjian

2004-09-28	Code review for recent dbsize changes. Fix some thinkos, enforce coding	Tom Lane
	style and message style standards, improve documentation.
2004-09-02	Remove line specifying Andreas as author.	Bruce Momjian

2004-09-02	The current implementation of dbsize doesn't handle tables in	Bruce Momjian
	tablespaces correctly, and is quite restricted on objects covered (only tables and databases, but not tablespaces and indexes). The attached patch contributes: - database_size(name) - relation_size(text) These are the well-known functions, tablespace-aware. - pg_tablespace_size(oid) - pg_database_size(oid) - pg_relation_size(oid) Tablespace-aware implementations, used by the upper functions. pg_relation_size will report sizes of indexes as well. - pg_size_pretty(bigint) Formatting of sizes, to display '146MB' instead of '152885668' Andreas Pflug
2004-08-29	Pgindent run for 8.0.	Bruce Momjian

2004-08-12	dbsize modification to support tablespaces	Bruce Momjian
	Gavin Sherry
2004-02-23	Replace opendir/closedir calls throughout the backend with AllocateDir	Tom Lane
	and FreeDir routines modeled on the existing AllocateFile/FreeFile. Like the latter, these routines will avoid failing on EMFILE/ENFILE conditions whenever possible, and will prevent leakage of directory descriptors if an elog() occurs while one is open. Also, reduce PANIC to ERROR in MoveOfflineLogs() --- this is not critical code and there is no reason to force a DB restart on failure. All per recent trouble report from Olivier Hubaut.
2003-08-04	pgindent run.	Bruce Momjian

2003-07-24	Error message editing in contrib (mostly by Joe Conway --- thanks Joe!)	Tom Lane

2002-09-04	pgindent run.	Bruce Momjian

2002-08-29	Code review for standalone composite types, query-specified composite	Tom Lane
	types, SRFs. Not happy with memory management yet, but I'll commit these other changes.
2002-08-09	has_table_privilege spawns scions has_database_privilege, ↵	Tom Lane
	has_function_privilege, has_language_privilege, has_schema_privilege to let SQL queries test all the new privilege types in 7.3. Also, add functions pg_table_is_visible, pg_type_is_visible, pg_function_is_visible, pg_operator_is_visible, pg_opclass_is_visible to test whether objects contained in schemas are visible in the current search path. Do some minor cleanup to centralize accesses to pg_database, as well.
2002-07-20	oid is needed, it is added at the end of the struct (after the null	Bruce Momjian
	bitmap, if present). Per Tom Lane's suggestion the information whether a tuple has an oid or not is carried in the tuple descriptor. For debugging reasons tdhasoid is of type char, not bool. There are predefined values for WITHOID, WITHOUTOID and UNDEFOID. This patch has been generated against a cvs snapshot from last week and I don't expect it to apply cleanly to current sources. While I post it here for public review, I'm working on a new version against a current snapshot. (There's been heavy activity recently; hope to catch up some day ...) This is a long patch; if it is too hard to swallow, I can provide it in smaller pieces: Part 1: Accessor macros Part 2: tdhasoid in TupDesc Part 3: Regression test Part 4: Parameter withoid to heap_addheader Part 5: Eliminate t_oid from HeapTupleHeader Part 2 is the most hairy part because of changes in the executor and even in the parser; the other parts are straightforward. Up to part 4 the patched postmaster stays binary compatible to databases created with an unpatched version. Part 5 is small (100 lines) and finally breaks compatibility. Manfred Koizar
2002-05-20	Restructure indexscan API (index_beginscan, index_getnext) per	Tom Lane
	yesterday's proposal to pghackers. Also remove unnecessary parameters to heap_beginscan, heap_rescan. I modified pg_proc.h to reflect the new numbers of parameters for the AM interface routines, but did not force an initdb because nothing actually looks at those fields.
2002-04-02	Fix contrib/dbsize for schema-qualified table names.	Tom Lane

2002-02-22	I've written on like that a while ago:	Bruce Momjian
	http://webmail.postgresql.org/~petere/dbsize.html The tarball can be rolled into contrib -- now that I think of it I don't know why I never did that. Never imagined this would have anything to do with that TODO item, though. I figured oid2name accomplished that. Peter Eisentraut peter_e@gmx.net