Re: SQL Property Graph Queries (SQL/PGQ)

From: Junwang Zhao <zhjwpku(at)gmail(dot)com>
To: Ashutosh Bapat <ashutosh(dot)bapat(dot)oss(at)gmail(dot)com>
Cc: Kirill Reshke <reshkekirill(at)gmail(dot)com>, Peter Eisentraut <peter(at)eisentraut(dot)org>, assam258(at)gmail(dot)com, Amit Langote <amitlangote09(at)gmail(dot)com>, Vik Fearing <vik(at)postgresfriends(dot)org>, Ajay Pal <ajay(dot)pal(dot)k(at)gmail(dot)com>, Imran Zaheer <imran(dot)zhir(at)gmail(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: SQL Property Graph Queries (SQL/PGQ)
Date: 2026-03-17 10:27:11
Message-ID: CAEG8a3KsM_7qgEzbwCbwatZpoWVsXyR_G_GNYiqqnn-AJ8ASwQ@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Tue, Mar 17, 2026 at 5:54 PM Ashutosh Bapat
<ashutosh(dot)bapat(dot)oss(at)gmail(dot)com> wrote:
>
> On Tue, Mar 17, 2026 at 12:05 PM Junwang Zhao <zhjwpku(at)gmail(dot)com> wrote:
> > > >
> > > > Andrew mentioned in the SQL/PGQ commit thread that we should
> > > > fence the dependency check in pg_dump.c, maybe collecting it
> > > > in your patch set, see:
> > > >
> > > > https://www.postgresql.org/message-id/attachment/192197/fix-propgraph-def.patch
> > >
> > > Can you please share the link to the message? This is an attachment
> > > without message context.
> >
> > here
> >
> > https://www.postgresql.org/message-id/afe3f099-3271-4fc4-8e32-467b5309affb%40dunslane.net
>
> Thanks Junwang.
>
> I see that without Andrew's patch the upgrade from an old cluster fails with
> pg_dump: error: query failed: ERROR: relation "pg_propgraph_element"
> does not exist
> LINE 7: ..., refclassid, refobjid, deptype FROM pg_depend d, pg_propgra...
>
> The error is fixed by Andrew's changes. But the patch is already
> committed by Peter.

Ok, then the patch set LGTM.

>
> --
> Best Wishes,
> Ashutosh Bapat

--
Regards
Junwang Zhao

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Jelte Fennema-Nio 2026-03-17 10:31:04 Re: Don't use the deprecated and insecure PQcancel in our frontend tools anymore
Previous Message 2026-03-17 10:26:23 Re: [PATCH] Docs: clarify default values of EXPLAIN BUFFERS and SERIALIZE