Re: [PATCHES] dbsize patch

2005-01-26 Thread Ed L.
On Thursday January 27 2005 12:08, Neil Conway wrote: > On Thu, 2005-01-27 at 08:05 +0100, Michael Paesold wrote: > > Perhaps you could rename indices_size to indexes_size. > > Yeah, sorry -- forgot to mention that. I believe we decided to > standardize on "indexes" as the plural of "index" (at lea

Re: [PATCHES] dbsize patch

2005-01-26 Thread Neil Conway
On Thu, 2005-01-27 at 08:05 +0100, Michael Paesold wrote: > Perhaps you could rename indices_size to indexes_size. Yeah, sorry -- forgot to mention that. I believe we decided to standardize on "indexes" as the plural of "index" (at least in user-visible stuff) a few releases go. Good catch :) -N

Re: [PATCHES] dbsize patch

2005-01-26 Thread Michael Paesold
Neil Conway wrote: On Tue, 2005-01-25 at 16:49 -0700, Ed L. wrote: The attached dbsize patch: + makes relation_size(relname) include toast tables; + adds aggregate_relation_size(relname) to count table data and indices; + adds indices_size(relname) to report the size of indices for a relation; I'

Re: [PATCHES] Move get_grosysid() to utils/cache/lsyscache.c

2005-01-26 Thread Neil Conway
On Wed, 2004-12-29 at 11:36 -0500, Stephen Frost wrote: > Small patch to move get_grosysid() from catalog/aclchk.c to > utils/cache/lsyscache.c where it can be used by other things. Also > cleans up both get_usesysid() and get_grosysid() a bit. This is in > preparation for 'Group Ownersh

Re: [PATCHES] Increased error verbosity when querying row-returning

2005-01-26 Thread Neil Conway
On Wed, 2005-01-12 at 17:34 +1100, Brendan Jurd wrote: > Thanks Alvaro, changes made and new patch attached. Applied to HEAD -- thanks for the patch. Another style tip: we don't accept code that produces compiler warnings (pretty much), so checking that before submitting patches would be nice. -

Re: [PATCHES] Multi-table truncate

2005-01-26 Thread Tom Lane
Alvaro Herrera <[EMAIL PROTECTED]> writes: > This is my multi-table truncate patch. Includes doc changes and couple > new regression tests. Applied with minor editorialization. regards, tom lane ---(end of broadcast)--- TIP

Re: [PATCHES] dbsize patch

2005-01-26 Thread Neil Conway
On Tue, 2005-01-25 at 16:49 -0700, Ed L. wrote: > The attached dbsize patch: > > + makes relation_size(relname) include toast tables; > + adds aggregate_relation_size(relname) to count table data and indices; > + adds indices_size(relname) to report the size of indices for a > r

Re: [PATCHES] Win32 pg_autovacuum service retry patch

2005-01-26 Thread Tom Lane
[EMAIL PROTECTED] writes: > Anyway... the attached patch to pg_autovacuum follows Tom's earlier suggestion > that it re-try the inital database connection every 30 seconds for 5 minutes > before aborting when starting as a Windows Service. Applied. regards, tom lane -

[PATCHES] Win32 pg_autovacuum service retry patch

2005-01-26 Thread dpage
Apologies in advance as my original attempt to send this message may well get through in a day or so now that Bob the Builder has finished digging up my fibre and copper and the telco has set about joining them all back together and burying them again. Anyway... the attached patch to pg_autovacuum

[PATCHES] Multi-table truncate

2005-01-26 Thread Alvaro Herrera
Hackers, This is my multi-table truncate patch. Includes doc changes and couple new regression tests. Note the following excerpt from the temp regression test: + BEGIN; + CREATE TEMP TABLE temptest3(col int PRIMARY KEY) ON COMMIT DELETE ROWS; + NOTICE: CREATE TABLE / PRIMARY KEY will create im

Re: [PATCHES] add soundex difference function to contrib/fuzzystrmatch

2005-01-26 Thread Neil Conway
Kris Jurka wrote: I've attached two new patches. One revising my original patch to make the function creations consistent and the other to just fix the problem in the existing code (which should be backported as far as people would like to). Full patch applied to HEAD, fix for STRICT applied to 8.