Postgres: trigger and session timeout

[shaphiro]

Hi,

I have developed a web application with a user identification system.
I use Postgres, Apache with php.

Anytime that a user access to the system I record the user data (time,date,user name, etc...) in the log_access table.
Now, when the session timeout I would like to run a trigger in order to write logout data in the log_access table.

How can I do this? With a trigger, I suppose.

Thanks.

[chriskl]

A trigger? I don't think so. In your php code that logs people in, pick a number between 0 and 1 at random. If the number is < 0.1 or something, then run an sql query to log out everyone whose time has expired.

Triggers can fire only when you insert,delete or update - postgres doesn't have statement triggers.

Chris