Re: (SQL/PGQ) cache lookup failed for label

From: zengman <zengman(at)halodbtech(dot)com>
To: Ashutosh Bapat <ashutosh(dot)bapat(dot)oss(at)gmail(dot)com>
Cc: pgsql-hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, Peter Eisentraut <peter(at)eisentraut(dot)org>
Subject: Re: (SQL/PGQ) cache lookup failed for label
Date: 2026-05-14 14:07:16
Message-ID: tencent_5A70518C7FF4E4EE46C464D3@qq.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> The patch needs a test. graph_table.sql already has some view
> definitions, some of them using elements with multiple labels. Can you
> please add a test using those views? For example after CREATE VIEW
> customer_us, you could add a statement dropping label list_items from
> all of the elements associated with that label. I guess
> pg_get_viewdef() itself should throw an error with the fix, but you
> could select from that view as well, if necessary. We also need a test
> for drop property. Remember that the property is completely dropped
> from a property graph only when it is dropped from all the labels
> containing that property. Please apply patches from [1] before adding
> tests to your patch. With those patches added your test queries above
> will throw a different error.
>
> [1] https://www.postgresql.org/message-id/CAExHW5tCCQhgDEfBTKWqe7bDqCUXhPpsqoGipL7Vpf0epcKkXA@mail.gmail.com
>

Hi Ashutosh,

Thank you for the review and sorry for the late reply. I'm currently busy with company projects and may not have time to work on this right now.
If this is urgent, would you mind handling it? If it can wait, I'll come back and fix it when I have more availability.

--
regards,
Man Zeng

In response to

Browse pgsql-hackers by date

  From Date Subject
Previous Message Alexander Korotkov 2026-05-14 13:39:04 Re: Fix bug with accessing to temporary tables of other sessions