Georg Traar

I think part of the confusion comes from https://crate.io/docs/crate/reference/en/4.8/interfaces/postgres.html#database-selection > Since CrateDB uses schemas instead of databases, the database parameter sets the default schema name for future queries. If no...

Hi @iosifnicolae2 CrateDB does not yet support `set_config(setting_name, new_value, is_local)` which is a pg-specific alias for `SET setting_name = new_value`. While the compatibility with many PG integrations is rising release...

@seut / @jweberpm feedback appreciated

> Any chance we could get this merged into main before the 5.0 release is cut? @seut / @mfussenegger I think this would need some rework (i.e. split up logic...

[Rudderstack](https://www.rudderstack.com/docs/reverse-etl/postgresql/#granting-permissions) is trying to use a schema with `_` underscore ```sql GRANT ALL ON SCHEMA "_rudderstack" TO RUDDER; ```

relevant for [Dataiku](https://www.dataiku.com/de/)

> any solution how can i collect cratedb metrics using jxm ? Maybe this article is helpful? https://crate.io/blog/monitoring-cratedb-with-prometheus-and-grafana Getting the JMX metrics via http is done via the JMX exporter:...

> Do you have some examples of such queries. What is the source type and source column in these cases? I have a few: ```sql select A.oid as access_method_id, A.xmin...

@mfussenegger That's what I tried and worked. I would think this should be implemented similar to `PG_SERVER_VERSION` in https://github.com/crate/crate/blob/05be94e1b100c9786b3689baaa13689b6642e7bd/server/src/main/java/io/crate/protocols/postgres/PostgresWireProtocol.java#L469

@mfussenegger according to https://crate.io/docs/crate/reference/en/4.6/general/dql/geo.html#exact-queries `distance()` doesn't Afaik it was mostly a performance issue i.e. much slower than having a column for filtering (0,0) positions