pg_duckdb icon indicating copy to clipboard operation
pg_duckdb copied to clipboard

Search path issues

Open Tishj opened this issue 1 year ago • 7 comments

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)

Tishj avatar Jun 11 '24 07:06 Tishj