hlcianfagna

Hi, this came out in the context of a discussion around https://crate.io/docs/crate/reference/en/4.8/interfaces/postgres.html#expressions there are no requests about this connected with actual production use cases I am aware of

There is another faster workaround ```sql SELECT device, split_part( MAX( CONCAT (date_format(ts), ',', speed::STRING) ) /* optionally FILTER(WHERE speed IS NOT NULL) to mimic IGNORE NULLS OVER ... */ ',',...

> startdateweekday as lower(date_format('%a', startdate)) This is already possible with generated columns: ```sql CREATE TABLE example1 ( startdate timestamp, startdateweekday generated always as lower(date_format('%a', startdate)) ); ``` > The use...

This is also used by Entity Framework Core

One possible option to give back a warning could be by means of a `NoticeResponse` with severity `WARNING` see https://www.postgresql.org/docs/current/protocol-flow.html and https://www.postgresql.org/docs/current/protocol-error-fields.html

Regarding the missing pg_catalog tables, trying to create mocks currently results on "Cannot create relation in read-only schema", perhaps allowing that could be a low-cost way of enabling workarounds?

> Regarding the missing pg_catalog tables, trying to create mocks currently results on "Cannot create relation in read-only schema", perhaps allowing that could be a low-cost way of enabling workarounds?...

@robd003 for the purpose of the `SELECT` query you shared it may be enough to mock the function like below, could you give this a try? ```sql CREATE FUNCTION pg_catalog.pg_table_is_visible(oid...

This is also relevant for Dataiku, they use the PosgreSQL JDBC driver, and rollback on exception, which fails and masks the original error. Dataiku Enterprise (more expensive - tested on...

> Is there any blueprint for that, for example how PostgreSQL does it? Hi, yes, maybe this could be based on `pg_stat_activity`