Re: Updatable Views and INSERT INTO ... ON CONFLICT

2022-09-02 Thread walther
Joel Jacobson: I note it's not yet possible to INSERT INTO an Updatable View using the ON CONFLICT feature. To be clear, it seems to be supported for AUTO-updatable views and for views with manually created RULES, but not for views with INSTEAD OF triggers. Not saying it is desired, just tr

Updatable Views and INSERT INTO ... ON CONFLICT

2022-01-01 Thread Joel Jacobson
Hi, I note it's not yet possible to INSERT INTO an Updatable View using the ON CONFLICT feature. One imaginable pattern is when a user wants to refactor by renaming a table, but for some reason cannot refactor some specific application and want to allow it to continue to use the table's old name