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...