On Fri, Aug 23, 2019 at 08:58:50AM -0500, Roberto Mireles wrote:
Hello team,
This is the first time I post here, if you can provide some help, would be
much appreciated.
I have an application that can not access the database due to OID value for
hstore extension is bigger than an integer value. Application uses a NpgSql
driver that only supports integer types for OIDs.
I'm not familiar with npgsql, but OID is an unsigned integer. So if you
have an OID greater than 2147483647, then that can't be converted into a
32-bit integer, of course (npgsql likely gets a text value, and then fails
while parsing it).
We have a new app version, which uses a new driver version that supports
bigint and has no issues at all, but for that specific database, we still
need to use that old version of the app.
I have searched for a workaround or something that can help us to be able
to connect to the database, but have not found anything related.
I also tried by dropping, creating extension again, but same result.
Does any of you know any workaround that can help here?
We are using postgresql 9.2.24.
Well, this is likely an issue you should raise with npgsql instead. I'd
assume they have a way to deal with OID values properly.
regards
--
Tomas Vondra http://www.2ndQuadrant.com
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
