Hi fellow list members. I hit a brick wall with my last question. I'd like to
try this again.
I need to remove OIDs from tables without locking the tables for long periods
of time. I have developed a strategy that seems to work, but I would like the
experts to weigh in since I'm planning on doi
On Wednesday, November 22, 2023 at 12:38:54 PM EST, Achilleas Mantzios
wrote:
Στις 22/11/23 15:14, ο/η CG έγραψε:
On Wednesday, November 22, 2023 at 01:20:18 AM EST, Achilleas Mantzios
wrote:
Στις 21/11/23 20:41, ο/η CG έγραψε:
I have a very
On Wednesday, November 22, 2023 at 01:20:18 AM EST, Achilleas Mantzios
wrote:
Στις 21/11/23 20:41, ο/η CG έγραψε:
I have a very large PostgreSQL 9.5 database that still has very large tables
with oids. I'm trying to get rid of the oids with as little downtime as
possib
ipe_oid_test; oid | k | v -+---+--- 0 | 1 | 2
0 | 3 | 4 0 | a | b 0 | c | d(4 rows)
I can modify pg_class and set relhasoids = false, but it isn't actually
eliminating the oid column. `\d+` will report not report that it has oids, but
the oid column is still present and returns the same result before updating
pg_class.
So I'm definitely missing something. I really need a point in the right
direction Please help! ;)
CG
