| From: | Peter Eisentraut <peter(at)eisentraut(dot)org> |
|---|---|
| To: | Ashutosh Bapat <ashutosh(dot)bapat(dot)oss(at)gmail(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Vertex/Edge label and view |
| Date: | 2026-08-17 13:18:02 |
| Message-ID: | 2b4bac52-9594-459b-9286-8a97baa59c07@eisentraut.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Xuneng Zhou | 2026-08-17 13:20:08 | Re: [WIP] Pipelined Recovery |
| Previous Message | Mihail Nikalayeu | 2026-08-17 13:16:37 | Re: Re-read conindid under the referenced table's lock in the RI fast path |