pg_duckdb
pg_duckdb copied to clipboard
Search path issues
If we create this table set up:
postgres=# select * from "s.tbl";
a
-----
abc
(1 row)
postgres=# select * from s.tbl;
a
-----
cde
(1 row)
We get this error when executing select * from "s.tbl", s.tbl;
postgres=# drop extension quack;
DROP EXTENSION
postgres=# create extension quack;
CREATE EXTENSION
postgres=# select * from "s.tbl", s.tbl;
WARNING: (Quack) Binder Error: Duplicate alias "s.tbl" in query!
a | a
-----+-----
abc | cde
(1 row)