Forum OpenACS Q&A: Trouble deleting rows from sec_sessions

Collapse
1: Trouble deleting rows from sec_sessions
Posted by Tom Jackson on 09/20/02 04:38 PM

I am having trouble deleting rows from sec_sessions in an OpenACS 3.x system. Here is an example of what I tried: 

l=# select count(*) from sec_sessions where session_id =  883640;
 count
-------
     1
(1 row)
 
l=# delete from sec_sessions where session_id = 883640;
DELETE 0

Any hints on why the silent failure?

Collapse
2: Response to Trouble deleting rows from sec_sessions (response to 1)
Posted by Jonathan Ellis on 09/20/02 05:06 PM
Carl C-M ran into this a year ago. His thread is here. There's an ON DELETE trigger returning null that cancels the delete, was the problem. Dunno if there's a patch submitted or not.
Collapse
3: Response to Trouble deleting rows from sec_sessions (response to 1)
Posted by Tom Jackson on 09/20/02 05:08 PM

I had a feeling that might be the case, thanks!

Collapse
4: Response to Trouble deleting rows from sec_sessions (response to 1)
Posted by Allan Regenbaum on 09/22/02 05:29 AM