updatable/deletable terminology

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: updatable/deletable terminology
Date: 2013-08-08 01:19:03
Message-ID: 1375924743.17807.4.camel@vanquo.pezone.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

We have these two error messages:

To make the view updatable, provide an unconditional ON UPDATE DO INSTEAD rule or an INSTEAD OF UPDATE trigger.

and

To make the view updatable, provide an unconditional ON DELETE DO INSTEAD rule or an INSTEAD OF DELETE trigger.

I think it's a bit strange to claim that adding a DELETE rule/trigger
makes a view *updatable*. I suspect someone thought they would apply
the term "updatable" in an SQL standard sense, but that seems backwards,
because you get to these error conditions exactly because the view as
defined was not Updatable(tm).

Or perhaps "deletable" isn't such a good word here?

Maybe "To enable updates/deletions in the view, ..."?

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Eisentraut 2013-08-08 01:25:06 MultiXactId concept underdocumented
Previous Message Josh Berkus 2013-08-08 00:58:06 Re: 9.4 regression