| From: | Peter Eisentraut <peter(at)eisentraut(dot)org> |
|---|---|
| To: | pgsql-committers(at)lists(dot)postgresql(dot)org |
| Subject: | pgsql: Add test for view referencing labels shared by vertex and edge t |
| Date: | 2026-08-25 13:50:49 |
| Message-ID: | E1wyrY8-0000000242U-1XSi@gemulon.postgresql.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-committers |
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(dot)bapat(dot)oss(at)gmail(dot)com>
Discussion: https://www.postgresql.org/message-id/flat/CAExHW5toFV8b984ipuBSAar-W50K%3D%2BXmPOcG5ZUZNP4jrf4zSg%40mail.gmail.com
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(+)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Fujii Masao | 2026-08-26 01:38:02 | pgsql: doc: Update REPACK-related table rewrite documentation |
| Previous Message | Peter Eisentraut | 2026-08-25 12:17:46 | pgsql: Revert "Remove old readline API workaround" |