pg_duckdb icon indicating copy to clipboard operation
pg_duckdb copied to clipboard

Switch from replacement scans to using catalogs

Open Mytherin opened this issue 1 year ago • 2 comments

  • This allows us to insert into tables by defining a custom insert operator
  • This makes schemas work natively without needing the current work-around

Mytherin avatar Jun 24 '24 15:06 Mytherin

This issue would be fixed as a side-effect

Tishj avatar Jun 25 '24 10:06 Tishj

This issue would be fixed as a side-effect

Little update on this: it won't be entirely fixed by this, DuckDB has some limitations on bindings, and with this change we have less control over aliasing to work around those so this will eventually need to be fixed upstream

SELECT count(*) FROM public.t, other.t; will fail as both public.t and other.t will be aliased as t We previously worked around this limitation by aliasing as "public.t" and "other.t"

Tishj avatar Aug 06 '24 09:08 Tishj

Closing this since #97 was merged

JelteF avatar Sep 24 '24 17:09 JelteF