Re: SQL Property Graph Queries (SQL/PGQ) - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: SQL Property Graph Queries (SQL/PGQ)
Date
Msg-id 6fc1c996-93b1-43df-ba13-e94933cf3dfb@eisentraut.org
Whole thread Raw
In response to Re: SQL Property Graph Queries (SQL/PGQ)  (Ashutosh Bapat <ashutosh.bapat.oss@gmail.com>)
Responses Re: SQL Property Graph Queries (SQL/PGQ)
List pgsql-hackers
On 20.03.26 14:42, Ashutosh Bapat wrote:
>> We should either:
>>
>> (1) Support G041 fully -- both directions. Junwang's patch handles
>>      this cleanly with minimal code change, or
>> (2) Not support G041 -- reject all non-local element pattern
>>      references, throwing an error for both directions.
>>
>> What do you think?
> 
> We will support the cross variable references in future once we
> support more path patterns leading to a more mature code in that area.
> But it doesn't harm to support backward references which can be easily
> supported now. I don't see the code to do so getting disturbed as it
> matures. For the segmentation fault a simple fix to add graph_pattern
> suffices for now. Let's see if Peter has a different opinion.

I think we should not allow non-local references in either direction 
(until we implement feature G041), option 2 above.  Allowing only 
backward references seems kind of an arbitrary implementation artifact.




pgsql-hackers by date:

Previous
From: Amit Kapila
Date:
Subject: Re: [Proposal] Adding Log File Capability to pg_createsubscriber
Next
From: Peter Smith
Date:
Subject: Re: Initial COPY of Logical Replication is too slow