Re: [GENERAL] Audit-trail engine inner-workings

2007-08-27 Thread Manuel Sugawara
"Marcelo de Moraes Serpa" <[EMAIL PROTECTED]> writes: > I know that this PostgreSQL C module has a static var that in turn keeps the > integer set by the function "set_session_id" - but is this var global to the > server's service ? Does PostgreSQL mantain one "instance" of this var per > requeste

Re: [GENERAL] Audit-trail engine inner-workings

2007-08-22 Thread Marcelo de Moraes Serpa
Hey Ted, thanks for the reply, In respect of web application architecture, I'm fully aware of session persistence mechanisms (I work as a developer of web apps after all). What I really would like to know is the inner-workings of the set_session_id and current_session_id as well as reset_session_

Re: [GENERAL] Audit-trail engine inner-workings

2007-08-21 Thread Ted Byers
--- Marcelo de Moraes Serpa <[EMAIL PROTECTED]> wrote: > Hello list, > [snip] > > * Each http request gets an instance of a session_id > ? Or is it > per-connection ? It depends. There is no necessary correlation between a session as defined within a web application and a session as defined i

[GENERAL] Audit-trail engine inner-workings

2007-08-21 Thread Marcelo de Moraes Serpa
Hello list, Taking this discussion as a base: http://archives.postgresql.org/pgsql-general/2007-04/msg01034.php Manuel helped me to develop an audit-trail engine, and even though it works ok, I need to know better its inner workings: >From what I understand, the flow is something like this: