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