Forum OpenACS Q&A: Response to Cannot delete from a view

Posted by Vinod Kurup on
Yeah, I noticed this too. Did you recently update to postgres 7.1?

I noticed that insert, update or delete's on views are no longer allowed in pg 7.1. See the release history (under bugfixes)

I did a little testing:

  • in PG 7.03, deleting from a view deletes rows in the view, but not in the underlying table
  • in PG 7.1b6, deleting from a view is not allowed
  • in Oracle 8.1.6 deleting from a view deletes rows from the view and from the underlying table
  • Anyone know why disallowing dml statements on a view is a bugfix? (asking sincerely, cuz I don't know)