Dapper Issues while connecting to Postgres DB

[lechu90ns]

Hey Guys!

I am not able to connect, from a fresh Serene 8.4.8 version, with using Npgsql (v8.0.3). The problem occurs when Serenity tries to Query DB with Dapper select * from postgres.pg_catalog.pg_database where datname = @name:

then Dapper has an issue with calculating hash by using GetColumnHash

and on datacl column it throws an error from npgsql.internal:

System.InvalidCastException: 'Reading as 'System.Object' is not supported for fields having DataTypeName 'aclitem[]''

Not sure, how I can fix that. Did anyone get a similar issue with Postgres or know how to fix it?

Thanks!

[lechu90ns]

It seems that filtering columns fix the issue

select datname from postgres.pg_catalog.pg_database where datname = @name

However, it needs to be fixed on Serenity package

[lechu90ns]

Can anyone review this PR to fix the issue for postgres DB connectors?

serenity-is/common-features#37