Can't process CITEXT

[tobq]

In the passed, I had to register a custom codec to process the citext.
Is there a reason the library doesn't handle citext itself?

One issue I found with my custom codec is that the OID isn't always the same - it was different on my local machine than to my server

Caused by: java.lang.IllegalArgumentException: Cannot decode value of type java.lang.Object with OID 16395
	at io.r2dbc.postgresql.codec.DefaultCodecs.decode(DefaultCodecs.java:180) ~[r2dbc-postgresql-0.8.10.RELEASE.jar:0.8.10.RELEASE]

[tobq]

I guess it could be argued that there's no appropriate (native) java type that can represent CITEXT, so the citext should be converted to a normal string before reaching the driver?

[mp911de]

citext seems an optional module. It would make sense to register a StringCodec for a given OID to be able to read such values as String. Take a look at https://github.com/pgjdbc/r2dbc-postgresql/blob/main/src/main/java/io/r2dbc/postgresql/codec/BuiltinDynamicCodecs.java.