On 17.08.26 15:18, Peter Eisentraut wrote:
On 07.08.26 08:47, Ashutosh Bapat wrote:
Otherwise, standard needs to define the result of the query when a
label exists but is not associated with any element of required type -
which essentially would mean returning 0 rows since there are no
elements associated with the label.
I think we need the standard to define the behaviour in such a case.
The standard does define that behavior: Using a label that is not
associated with an element of the right type is a syntax error.
What we are not doing correctly is that DROP LABEL should either
RESTRICT if a view exists or CASCADE, as appropriate.
So there is room for improvement, but I'm not too bothered by the
current behavior. You get a clear error message and nothing incorrect
happens.
I have committed the test case you had proposed.
