duckdb/duckdb-postgres

Views do not have "ctid"

Closed this issue · 1 comments

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

See #81