Forum OpenACS Development: Permission denied for relation todo_item

Hello,

I'm learning how OpenACS works with your tutorial and everything is ok and seems easier with your help.

But I cannot understand the problem I have in the example of entering new data in the database (Section 4).

When I try to insert the data from the form I get this error message:

------------

Database operation "dml" failed
(exception ERROR, "ERROR: permission denied for relation todo_item
")

while executing
"ns_pg_bind dml nsdb0 {insert into todo_item (item_id, title, description, status, due_date, owner_id) values (:item_id, :title, :description, :status,..."
("uplevel" body line 1)
invoked from within
"uplevel $ulevel [list ns_pg_bind $type $db $sql]"
("postgresql" arm line 2)
invoked from within
"switch $driverkey {
oracle {
return [uplevel $ulevel [list ns_ora $type $db $sql] $args]
}
..."
invoked from within
"db_exec dml $db $full_statement_name $sql"
("uplevel" body line 2)
invoked from within
"uplevel 1 $code_block "
invoked from within
"db_with_handle -dbn $dbn db {
db_exec dml $db $full_statement_name $sql
}"
...
...

-----------------

I have my dotLRN installation working correctly, installed from the tarball (2.4.1)

Thanks to everyone

It was true.

public | timezones | table | dotlrn
public | todo_item | table | postgres
public | total_num_required_segs | view | dotlrn
public | total_side_one_constraints | view | dotlrn
public | user_col_comments | view | dotlrn

Thanks a lot