Josh Berkus <josh@agliodbs.com> writes: > Eh? I thought that it was just syntatic sugar that was missing. I've > built lots of updatable views manually; I don't see what's difficult about > it.
I think you'll find that corner cases like inserts involving nextval() don't work real well with a rule-based updatable view. But perhaps I'm just scarred by the many complaints we've had about rules. With a plain unconditional DO INSTEAD rule it might be OK ... regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org