| From: | Alvaro Herrera <alvherre(at)2ndquadrant(dot)com> |
|---|---|
| To: | Roberto Mireles <roberto(dot)mireles(at)42-q(dot)com> |
| Cc: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Hstore OID bigger than an integer |
| Date: | 2019-08-23 15:40:23 |
| Message-ID: | 20190823154023.GA11538@alvherre.pgsql |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tomas Vondra | 2019-08-23 15:54:16 | Re: Hstore OID bigger than an integer |
| Previous Message | Alvaro Herrera | 2019-08-23 15:38:25 | Re: Cleanup isolation specs from unused steps |