Re: SQL Property Graph Queries (SQL/PGQ)

From: Ashutosh Bapat <ashutosh(dot)bapat(dot)oss(at)gmail(dot)com>
To: Junwang Zhao <zhjwpku(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 09:53:50
Message-ID: CAExHW5vYJ6tUgkCsX2pA88dcV_RE2YL0AeYBqJR7GeujBzSO7Q@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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.

--
Best Wishes,
Ashutosh Bapat

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrei Lepikhov 2026-03-17 10:04:25 Re: Read-only connection mode for AI workflows.
Previous Message Heikki Linnakangas 2026-03-17 09:52:57 Re: POC: make mxidoff 64 bits