Re: Removing OIDs without recreate

From: Együd Csaba <csegyud(at)vnet(dot)hu>
To: 'Karel Zak' <zakkr(at)zf(dot)jcu(dot)cz>
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 12:11:25
Message-ID: 003701c4342c$6bb5d2e0$230a0a0a@compaq
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Sorry I made a mistake, I saw docs for 7.4, because I use an other server
running that version.
So this won't work on 7.3.*.
Can I drop OID column painlessly? Does it lead to any problems?

Thank you,
-- Csaba

> -----Original Message-----
> From: 'Karel Zak' [mailto:zakkr(at)zf(dot)jcu(dot)cz]
> Sent: 2004. május 7. 14:06
> To: Együd Csaba
> Cc: 'Pgsql-General(at)Postgresql(dot)Org (E-mail)'
> Subject: Re: [GENERAL] Removing OIDs without recreate
>
>
> On Fri, May 07, 2004 at 01:59:39PM +0200, Együd Csaba wrote:
> > cygwin/7.3.4
> > The doc contains the option but doesn't work - at least for me.
>
> http://www.postgresql.org/docs/7.3/static/sql-altertable.html
>
> The ALTER TABLE ... SET WITHOUT OIDS is in new in 7.4
>
> Release 7.4 notes:
>
> ALTER TABLE ... WITHOUT OIDS (Rod)
>
> --
> Karel Zak <zakkr(at)zf(dot)jcu(dot)cz>
> http://home.zf.jcu.cz/~zakkr/
> ---
> Incoming 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.
>

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Lonni Friedman 2004-05-07 13:14:22 Re: vacuumdb is failing with NUMBER OF INDEX TUPLES NOT THE SAME AS HEAP
Previous Message 'Karel Zak' 2004-05-07 12:06:00 Re: Removing OIDs without recreate