pg.ddx.io pgsql-committers@postgresql.org mailing list archive
help / color / mirror / Atom feedFrom: Peter Eisentraut <peter@eisentraut.org>
To: pgsql-committers@lists.postgresql.org
Subject: pgsql: Add test for view referencing labels shared by vertex and edge t
Date: Tue, 25 Aug 2026 13:50:49 +0000
Message-ID: <E1wyrY8-0000000242U-1XSi@gemulon.postgresql.org> (raw)
Add test for view referencing labels shared by vertex and edge tables
Add a test for view containing labels which are shared by both vertex
and edge tables. When such a label is dropped from only vertex tables
or only edge tables, the view may be rendered invalid because it does
not find any elements associated with the label. Right now, you get
an error at run time. It would be correct per SQL standard to make
this a syntax error (parse time error), which would require some
restrict/cascade action when dropping labels. This is not a big
problem, because you still get a clean error, but it might be worth
improving sometime. Add a test case to record the current behavior.
Author: Ashutosh Bapat <ashutosh.bapat.oss@gmail.com>
Discussion: https://www.postgresql.org/message-id/flat/CAExHW5toFV8b984ipuBSAar-W50K%3D%2BXmPOcG5ZUZNP4jrf4zSg%4...
Branch
------
master
Details
-------
https://git.postgresql.org/pg/commitdiff/3c982c9bf1af994090a181c68f9407ff39d3ddf7
Modified Files
--------------
src/test/regress/expected/graph_table.out | 19 +++++++++++++++++++
src/test/regress/sql/graph_table.sql | 13 +++++++++++++
2 files changed, 32 insertions(+)
Message-ID: <E1wyrY8-0000000242U-1XSi@gemulon.postgresql.org>
Permalink: ../E1wyrY8-0000000242U-1XSi@gemulon.postgresql.org/
Also on: postgresql.org/message-id/E1wyrY8-0000000242U-1XSi@gemulon.postgresql.org
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-committers@postgresql.org
Cc: peter@eisentraut.org, pgsql-committers@lists.postgresql.org
Subject: Re: pgsql: Add test for view referencing labels shared by vertex and edge t
In-Reply-To: <E1wyrY8-0000000242U-1XSi@gemulon.postgresql.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox