| From: | Karel Zak <zakkr(at)zf(dot)jcu(dot)cz> |
|---|---|
| To: | Együd Csaba <csegyud(at)vnet(dot)hu> |
| Cc: | "Pgsql-General(at)Postgresql(dot)Org (E-mail)" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Removing OIDs without recreate |
| Date: | 2004-05-07 10:14:11 |
| Message-ID: | 20040507101410.GD621@zf.jcu.cz |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Fri, May 07, 2004 at 10:15:46AM +0200, Együd Csaba wrote:
> 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?
ALTER TABLE ... SET WITHOUT OIDS;
http://www.postgresql.org/docs/7.4/static/sql-altertable.html
Karel
--
Karel Zak <zakkr(at)zf(dot)jcu(dot)cz>
http://home.zf.jcu.cz/~zakkr/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dragan Matic | 2004-05-07 10:51:56 | How can I do conditional 'drop table' in Postgres |
| Previous Message | Bernard Cheung | 2004-05-07 08:18:43 | Trigger function to know which fields are being updated |