Re: Logging (was Re: Suggestion GRANT ALTER, TRIGGER ON

From: Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl>
To: "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, josh(at)agliodbs(dot)com, pgsql-hackers(at)postgresql(dot)org, David Fetter <david(at)fetter(dot)org>
Subject: Re: Logging (was Re: Suggestion GRANT ALTER, TRIGGER ON
Date: 2003-05-20 23:23:35
Message-ID: 20030520232335.GC2570@dcc.uchile.cl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)agliodbs(dot)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)

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Christopher Kings-Lynne 2003-05-21 01:51:12 Re: Suggestion GRANT ALTER, TRIGGER ON ALTER
Previous Message Alvaro Herrera 2003-05-20 23:21:23 Re: Removing width from EXPLAIN