Thijs

@Mytherin This seems like a problem, I can't really find the reason for this behavior ``` # Not aliased (no expression alias) statement ok CREATE VIEW s1.view_aliases.x AS SELECT 'x'...

> An example of a view that works in Postgres but wouldn't work in DuckDB might be: > > ```sql > create table my_table(i int); > create view my_view as...

The problem with this lies in `Binder::Bind(BaseTableRef &ref)` Even if I remove the query from the created ViewCatalogEntry, this code looks up the catalog entry, binds it and compares the...

The problem here is that we first bind the view's query before we hand it off to postgres, so we have to be able to bind it ourselves (possibly delegating...

We're likely going to have to separate out the SelectStatement inside the CreateViewInfo, then construct a postgres query from that, get the names + types from the PGresult object, and...

> good idea but no luck there, still consumes all available RAM (even on my larger machine with 120 GB) and crashes Just gathering some more potentially useful info: How...

https://github.com/duckdb/postgres_scanner/issues/189

With #212 the state of the implementation is now: Scan predicates of the query are applied to the `manifest_file` to determine if the scan predicate can not be satisfied by...

> [@Tishj](https://github.com/Tishj) Thank you pushing the code to handle partition fields with the identity transform. I am primarily using DayTransform any idea when this could be rolled out. > >...

@Vasampa23 see , this should make it possible to add day transforms, the main thing left to do there is add tests (see https://github.com/duckdb/duckdb-iceberg/pull/206 on how tests are preferably added)...