-
Notifications
You must be signed in to change notification settings - Fork 187
Description
- Driver: 0.8.6
PostgresTypes
does a LEFT JOIN
against the namespaces, resulting in multiple types being returned if the type is defined in multiple namespaces
r2dbc-postgresql/src/main/java/io/r2dbc/postgresql/codec/PostgresTypes.java
Lines 38 to 39 in ff5c93c
+ " LEFT " | |
+ " JOIN (select ns.oid as nspoid, ns.nspname, r.r " |
I have a type that is defined in multiple schemas (the schema is a "version", and application code is only using a specific version). This is controlled by the active schema, and current_schemas
will only return a single one. If I have a type defined in 3 schemas, I will receive three results from PostgresTypes
as it does a LEFT JOIN
against the visible namespaces rather than an INNER JOIN
.
If the LEFT JOIN
behavior is desired, adding the namespace to the returned object would allow filtering in application code.