Re: [HACKERS] A modest proposal: get rid of GUC's USERLIMIT

2004-11-13 Thread Andrew McMillan
On Thu, 2004-11-11 at 23:05 -0500, Bruce Momjian wrote: Andrew McMillan wrote: -- Start of PGP signed section. On Wed, 2004-11-10 at 11:45 -0500, Tom Lane wrote: Andrew McMillan [EMAIL PROTECTED] writes: When tracking down gnarly problems in heavily multi-user applications enabling

Re: [HACKERS] A modest proposal: get rid of GUC's USERLIMIT

2004-11-11 Thread Andrew McMillan
On Wed, 2004-11-10 at 11:45 -0500, Tom Lane wrote: Andrew McMillan [EMAIL PROTECTED] writes: When tracking down gnarly problems in heavily multi-user applications enabling higher log levels at selective points has the potential to help _a lot_ with diagnostic detail, without smothering you

Re: [HACKERS] [PATCHES] CVS should die

2004-11-06 Thread Andrew McMillan
On Fri, 2004-11-05 at 15:37 -0500, Tom Lane wrote: One of the reasons I'm disinclined to move is that none of the proposed alternatives seem especially, um, mature. AFAIK this project has never had CVS lose any data in the eight years we've used it. I'd want a comparable level of trust in

Re: [HACKERS] LinuxTag wrapup

2004-07-05 Thread Andrew McMillan
the environment to even install on a Debian system :-( Regards, Andrew McMillan. - Andrew @ Catalyst .Net .NZ Ltd, PO Box 11-053, Manners St, Wellington WEB: http://catalyst.net.nz

Re: [HACKERS] casting for dates

2001-09-26 Thread Andrew McMillan
On Thu, 2001-09-27 at 08:30, Vince Vielhaber wrote: I'm trying to use an integer from a table to add/subtract time in months. IOW: create table foo(nummonths int); select now() - nummonths months; newsroom=# select now() - interval( text(3) || ' months'); ?column?

Re: [HACKERS] Link to bug webpage

2001-08-21 Thread Andrew McMillan
application. If Bugzilla were installed I'm sure some functionality could be added into it along the lines of the Debian BTS too. Regards, Andrew. -- _ Andrew McMillan, e-mail: Andrew

Re: [HACKERS] Postgresql log analyzer

2001-08-21 Thread Andrew McMillan
want this to be an option, I guess. I imagine you could do this by getting the EXPLAIN at log analysis time if it isn't in the logs. Cheers, Andrew. -- _ Andrew McMillan, e-mail

Re: [HACKERS] Incomplete idea about views and INSERT...RETURNING

2001-07-22 Thread Andrew McMillan
an INSERT ... RETURNING query and that the RETURNS ... should either use values from that, or use a SELECT clause keyed on values from that? Cheers, Andrew. -- _ Andrew McMillan, e

Re: [HACKERS] SAPDB Open Souce

2001-04-29 Thread Andrew McMillan
. -- _ Andrew McMillan, e-mail: [EMAIL PROTECTED] Catalyst IT Ltd, PO Box 10-225, Level 22, 105 The Terrace, Wellington Me: +64(21)635-694, Fax: +64(4)499-5596, Office: +64(4)499-2267xtn709 ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http

Re: [HACKERS] --tuning compile and runtime option (?)

2001-04-10 Thread Andrew McMillan
, Andrew. -- _ Andrew McMillan, e-mail: [EMAIL PROTECTED] Catalyst IT Ltd, PO Box 10-225, Level 22, 105 The Terrace, Wellington Me: +64 (21) 635 694, Fax: +64 (4) 499 5596, Office: +64

Re: [HACKERS] Speaking of Indexing... (Text indexing)

2001-04-10 Thread Andrew McMillan
. -- _ Andrew McMillan, e-mail: [EMAIL PROTECTED] Catalyst IT Ltd, PO Box 10-225, Level 22, 105 The Terrace, Wellington Me: +64 (21) 635 694, Fax: +64 (4) 499 5596, Office: +64 (4) 499 2267 ---(end of broadcast)--- TIP 3

Re: [HACKERS] Re: xlog loose ends, continued

2001-03-13 Thread Andrew McMillan
extracted before you nuke it all and start over. Cheers, Andrew. -- _ Andrew McMillan, e-mail: [EMAIL PROTECTED] Catalyst IT Ltd, PO Box 10-225, Level 22, 105 The Terrace, Wellington Me: +6

Re: [HACKERS] How to shoot yourself in the foot: kill -9 postmaster

2001-03-07 Thread Andrew McMillan
. -- _ Andrew McMillan, e-mail: [EMAIL PROTECTED] Catalyst IT Ltd, PO Box 10-225, Level 22, 105 The Terrace, Wellington Me: +64 (21) 635 694, Fax: +64 (4) 499 5596, Office: +64 (4) 499 2267 ---(end of broadcast)--- TIP

Re: [HACKERS] mailing list messages

2001-03-06 Thread Andrew McMillan
must all be able to come up with 100 or so little one or two liners about PostgreSQL can't we? Just a thought, Andrew. -- _ Andrew McMillan, e-mail: [EMAIL PROTECTED] Catalyst

Re: [HACKERS] Upper limit on number of buffers?

2000-12-31 Thread Andrew McMillan
. -- _ Andrew McMillan, e-mail: [EMAIL PROTECTED] Catalyst IT Ltd, PO Box 10-225, Level 22, 105 The Terrace, Wellington Me: +64 (21) 635 694, Fax: +64 (4) 499 5596, Office: +64 (4) 499 2267

Re: [HACKERS] Why vacuum?

2000-12-14 Thread Andrew McMillan
Andrew. -- _____ Andrew McMillan, e-mail: [EMAIL PROTECTED] Catalyst IT Ltd, PO Box 10-225, Level 22, 105 The Terrace, Wellington Me: +64 (21) 635 694, Fax: +64 (4) 499 5596, Office: +64 (4) 499 2267

Re: [HACKERS] Import text field

2000-11-24 Thread Andrew McMillan
... DELIMITER ... sort of mechanism in PostgreSQL. E-mail me privately if you want a copy. Regards, Andrew. -- _ Andrew McMillan, e-mail: [EMAIL PROTECTED] Catalyst IT Ltd, PO Box

Re: [HACKERS] Full text indexing (Question/request)

2000-10-17 Thread Andrew McMillan
or keyword indexing natively in PostgreSQL. Regards, Andrew. -- _ Andrew McMillan, e-mail: [EMAIL PROTECTED] Catalyst IT Ltd, PO Box 10-225, Level 22, 105 The Terrace, Wellington Me