Forum OpenACS Q&A: Errors after restoring 3.2.4 in Postgres 7.1

Collapse
1: Errors after restoring 3.2.4 in Postgres 7.1
Posted by Pascal Scheffers on 04/06/01 09:13 AM
I received this error from the todo module in my mail this morning. I could not find it in the SDM, the restore had no errors (other than the duplicate define errors). I will try to figure out what has gone wrong, but if anyone can give me a hint, please do. 
[06/Apr/2001:08:00:00]
    Error: dbinit: error(localhost:5433:webpascal,ERROR:  Cannot
delete from a view without an appropriate
rule
    ): 'delete from deleted_todo_items where (deletion_date+
timespan_days(2))<sysdate()'

[06/Apr/2001:08:00:00]
    Error: Database operation "dml" failed
    Database operation "dml" failed
        while executing
    "ns_db dml $db "delete from deleted_todo_items where
(deletion_date+ timespan_days(2))<sysdate()""
        (procedure "todo_delete_old_items" line 4)
        invoked from within
    "todo_delete_old_items"
    Notice: dbinit: closing idle handle in pool 'subquery'
Collapse
2: Response to Errors after restoring 3.2.4 in Postgres 7.1 (response to 1)
Posted by Vinod Kurup on 04/06/01 10:04 AM
This is due to a change in PG7.1 that disallows DML statements in views. I believe it's scheduled to be fixed in a later version of PG., but for the time being, Roberto has fixed this issue in 3.2.5 so that the deletion is done on the underlying table, not the view. (see this thread)