Re: Hstore OID bigger than an integer

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