Removing OIDs without recreate

From: Együd Csaba <csegyud(at)vnet(dot)hu>
To: "Pgsql-General(at)Postgresql(dot)Org (E-mail)" <pgsql-general(at)postgresql(dot)org>
Subject: Removing OIDs without recreate
Date: 2004-05-07 08:15:46
Message-ID: 001801c4340b$80a38060$230a0a0a@compaq
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,
I'm winder if I can change the clause 'WITH OIDS' to 'WITHOUT OIDS' on a
table without recreating it (eg. usong ALTER TABLE). The problem is that my
tables are very big, and I do not need the OIDs at all. It was a mistake to
create them with OIDs.
Is there any way to correct it. Does it make any sense? Can it run out of
OIDs during time?

many thanks,
-- Csaba Együd

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com)
Version: 6.0.677 / Virus Database: 439 - Release Date: 2004. 05. 04.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bernard Cheung 2004-05-07 08:18:43 Trigger function to know which fields are being updated
Previous Message Bastian 2004-05-07 07:54:14 Re: Verhindern, dass im Mehrbenutzerbetrieb mit veralteten Daten gearbteitet wird