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
