cwida / duckpgq-extension

DuckDB extension that adds support for SQL/PGQ
https://duckpgq.notion.site/b8ac652667964f958bfada1c3e53f1bb?v=3b47a8d44bdf4e0c8b503bf23f1b76f2
MIT License
86 stars 7 forks source link

Support property graph creation over views #159

Open Dtenwolde opened 4 weeks ago

Dtenwolde commented 4 weeks ago

What happens?

As highlighted in #158 it is currently not possible to create a property graph containing a view. Internally views are ViewCatalogEntry instead of TableCatalogEntry, which we rely on to figure out whether the PK-FK relationship is correct for the vertex tables and edge tables. Perhaps we can do something to support views as well. Or we should choose to not support this, but it is worth an investigation at least.

To Reproduce

-

OS:

macOs 13 - Apple M1 Pro

DuckDB Version:

v1.1.2

DuckDB Client:

CLI

Full Name:

Daniel ten Wolde

Affiliation:

CWI

How did you load the extension?

Built from source

Did you include all relevant data sets for reproducing the issue?

Yes

Did you include all code required to reproduce the issue?

Did you include all relevant configuration (e.g., CPU architecture, Python version, Linux distribution) to reproduce the issue?