Re: [GENERAL] Audtiting, DDL and DML in same SQL Function

2012-02-02 Thread Christian Ramseyer
On 2/2/12 12:39 AM, Scott Marlowe wrote: > On Wed, Feb 1, 2012 at 4:27 PM, Scott Marlowe wrote: >> On Wed, Feb 1, 2012 at 3:29 PM, Christian Ramseyer wrote: >>> Optimally, I'd just have my applications perform a single >>> call after connecting, e.g. "audit_init('USERNAME', 'Name of application')

Re: [GENERAL] Audtiting, DDL and DML in same SQL Function

2012-02-02 Thread Dean Rasheed
On 1 February 2012 22:29, Christian Ramseyer wrote: > Hello list > > I'm trying to build a little trigger-based auditing for various web > applications. They have many users in the application layer, but they > all use the same Postgres DB and DB user. > > So I need some kind of session storage to

Re: [GENERAL] Audtiting, DDL and DML in same SQL Function

2012-02-01 Thread Scott Marlowe
On Wed, Feb 1, 2012 at 4:27 PM, Scott Marlowe wrote: > On Wed, Feb 1, 2012 at 3:29 PM, Christian Ramseyer wrote: >> Hello list >> >> I'm trying to build a little trigger-based auditing for various web >> applications. They have many users in the application layer, but they >> all use the same Pos

Re: [GENERAL] Audtiting, DDL and DML in same SQL Function

2012-02-01 Thread Scott Marlowe
On Wed, Feb 1, 2012 at 3:29 PM, Christian Ramseyer wrote: > Hello list > > I'm trying to build a little trigger-based auditing for various web > applications. They have many users in the application layer, but they > all use the same Postgres DB and DB user. > > So I need some kind of session stor

[GENERAL] Audtiting, DDL and DML in same SQL Function

2012-02-01 Thread Christian Ramseyer
Hello list I'm trying to build a little trigger-based auditing for various web applications. They have many users in the application layer, but they all use the same Postgres DB and DB user. So I need some kind of session storage to save this application level username for usage in my triggers, w