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:
* User sends http request to server to update some record (for example);
* The application server (tomcat) runs the servlet and the servlet gets a connection from the pool
* The servlet runs the "set_session_id(integer)" to set a session for this request and saves the current application user in the lookup table (session_id,user_id)
* The db operation is done (db saved) - the user name is retrieved through a lookup into the table mentioned above by getting this request's session_id by running the "current_session_id" SP
* Each http request gets an instance of a session_id ? Or is it per-connection ?
* Do I really need to call reset_session_id ? Isn't this connection destroyed after it has been used by the application?
* Would it work with an application which does not use a connection pool but a permanent connection (such as desktop apps)?
Thanks in advance!
Marcelo.
