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.
