Bug in handling OID numbers, surfacing with numbers > 2^31?

Erwin Brandstetter <[email protected]>
Newsgroups gmane.comp.db.postgresql.pgadmin.devel
Message-ID <CAGHENJ6tROEZt2gczhgQWsknmaXAfdp7J=CzY59SzRCwxiGv9g@mail.gmail.com>
Hi developers!

It would seem that pgAdmin4 pastes OID numbers as numeric literals instead
of string literals, if this report can be trusted:

https://dba.stackexchange.com/questions/247119/unable-to-output-data-from-tables-in-pgadmin-due-to-missing-oid-operator

Leads to sneaky errors with OIDs beyond 2^31. Details in the added answer
there. I did not recreate the issue as its hard to fake those OIDs.

Do you want me to add a bug report in Redmine?

Regards
Erwin
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.