On 2019-Aug-23, Roberto Mireles wrote:
> 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.
That's a bug in Npgsql. OIDs are unsigned.
> 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.
As a workaround, it would probably work to change the OID counter back
to the positive side of the signed value (probably using pg_resetxlog,
beware), then drop and recreate the extension.
--
Álvaro Herrera https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services