Views do not have "ctid"
Closed this issue · 1 comments
frafra commented
What happens?
Cannot use postgres_scan over a view, as ctid is not defined:
Error: IO Error: Unable to query Postgres: ERROR: column "ctid" does not exist
To Reproduce
Try to read a view
OS:
Ubuntu 22.04
PostgreSQL Version:
9.6.22
DuckDB Version:
v0.8.1
DuckDB Client:
v0.8.1
Full Name:
Francesco Frassinelli
Affiliation:
NINA
Have you tried this on the latest master branch?
- I agree
Have you tried the steps to reproduce? Do they include all relevant data and configuration? Does the issue you report still appear there?
- I agree