PeterHamilton/citier — Issue #40: Can not modify more than one base table through a join view
Author: mbcoder
Created: 2011-11-20 17:11:26+00:00
State: open

I'm still getting this error and I'm really not sure why. I've done all of your standard setup, but when I do save or save! it still causes:

> Can not modify more than one base table through a join view

I'm on the latest rails, cities, mysql2

And I'll add that in postgres it complains as well:

> ERROR: cannot update a view HINT: You need an unconditional ON UPDATE DO INSTEAD rule. : UPDATE "view_writing_assignments" SET "id" = 12, "heading" = 'This is a new writing assignment', "type" = 'WritingAssignment', "prompt" = 'Will it work? please please please?' WHERE "view_writing_assignments"."type" IN ('WritingAssignment') AND "view_writing_assignments"."id" = 12