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 requested

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

[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:

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 in the