Re: Issues with Information_schema.views - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Issues with Information_schema.views
Date
Msg-id 2127769.1698589854@sss.pgh.pa.us
Whole thread Raw
In response to Re: Issues with Information_schema.views  (Erki Eessaar <erki.eessaar@taltech.ee>)
List pgsql-hackers
Erki Eessaar <erki.eessaar@taltech.ee> writes:
> My question is - is all of this the intended behaviour by the implementers?

Yes, I'd say so.  If you are expecting that the is_updatable flag
will check to see if the behavior provided by the view's rules
corresponds to something that a human would call a corresponding
update of the view's output, you're out of luck.  There's a little
issue called the halting problem.  So the actual check just looks
to see if there's unconditional DO INSTEAD rules of the appropriate
types, and doesn't probe into what those rules do.

            regards, tom lane



pgsql-hackers by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: run pgindent on a regular basis / scripted manner
Next
From: Tom Lane
Date:
Subject: Re: On login trigger: take three