Skip site navigation (1) Skip section navigation (2)

Re: auditing in postgresql

From: Jeff Davis <pgsql(at)j-davis(dot)com>
To: Merlin Moncure <mmoncure(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: auditing in postgresql
Date: 2007-08-31 17:08:26
Message-ID: 1188580106.6199.71.camel@dogma.ljc.laika.com (view raw or flat)
Thread:
Lists: pgsql-general
On Thu, 2007-08-30 at 21:43 -0400, Merlin Moncure wrote:
> Well, a SRF may be unsuitable for various reasons, but maybe views are
> better. I really like views more and more lately (better than
> functions as a rule, I think).
> 
> you have some query, select yadda
> create view log_yadda as
>   select yadda
>     union all select null, null, null from log_func();
> 

Interesting idea, I hadn't thought of that. Not perfect, but
interesting.

The "returns query" might help reduce the penalty of using a SRF. Maybe
I'll look into that. 

Regards,
	Jeff Davis


In response to

Responses

pgsql-general by date

Next:From: Merlin MoncureDate: 2007-08-31 17:45:16
Subject: Re: auditing in postgresql
Previous:From: Marco BizzarriDate: 2007-08-31 16:54:32
Subject: computing and updating the size of a table with large objects

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group