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
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
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
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
