jkstill_at_gmail.com wrote:
>> Now, sometimes applications crash, leaving data in the spatial
>>tables. So, I'm going to do a little cronjob which cleans out
>>those tables once per day, probably midnight.
>>That job first gets all session id's and then deletes the data of
>>all non-active sessions.
>
>
> That is exactly what I am curious about.
>
> How do you plan to gather the session_id's and determine which are
> active?
If it would work, the query would look something like this:
select distinct sessionid
from
(
select sessionid from table1
union sessionid from table2
...
union sessionid from tableN
)
where not is_session_alive(sessionId);
Lots of Greetings!
Volker
Received on Mon Sep 12 2005 - 11:37:37 CDT
