Forum OpenACS Q&A: Re: Postgresql server error when inserting new data

Collapse
Posted by Derick Leony on
An INSERT into a CR view has a trigger attached to it, so it's rewritten into a SELECT.

The quick fix is to use db_0or1row instead of db_dml, but the best solution is to use the CR Tcl procs, content::revision::new in this case.