Re: Logging (was Re: Suggestion GRANT ALTER, TRIGGER ON - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: Logging (was Re: Suggestion GRANT ALTER, TRIGGER ON
Date
Msg-id 20030520232335.GC2570@dcc.uchile.cl
Whole thread Raw
In response to Re: Logging (was Re: Suggestion GRANT ALTER, TRIGGER ON  ("scott.marlowe" <scott.marlowe@ihs.com>)
Responses Re: Logging (was Re: Suggestion GRANT ALTER, TRIGGER ON  ("scott.marlowe" <scott.marlowe@ihs.com>)
List pgsql-hackers
On Tue, May 20, 2003 at 02:42:21PM -0600, scott.marlowe wrote:
> On Tue, 20 May 2003, Tom Lane wrote:
> 
> > Josh Berkus <josh@agliodbs.com> writes:
> > > I would propose
> > > SELECT
> > > INSERT/UPDATE
> > > DELETE
> > > DDL
> > 
> > Hm, why that particular division --- why separate DELETE but keep
> > INSERT and UPDATE together?
> 
> Why not just use a regex?  Then you could log exactly what you're looking 
> for.

I'd think a bitstring or some such is better... with a regex you are
sure going to drive the performance down.

-- 
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"El sudor es la mejor cura para un pensamiento enfermo" (Bardia)


pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Removing width from EXPLAIN
Next
From: "Christopher Kings-Lynne"
Date:
Subject: Re: Suggestion GRANT ALTER, TRIGGER ON ALTER