Re: Removing OIDs without recreate - Mailing list pgsql-general

From Együd Csaba
Subject Re: Removing OIDs without recreate
Date
Msg-id 003701c4342c$6bb5d2e0$230a0a0a@compaq
Whole thread Raw
In response to Re: Removing OIDs without recreate  ('Karel Zak' <zakkr@zf.jcu.cz>)
List 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@zf.jcu.cz]
> Sent: 2004. május 7. 14:06
> To: Együd Csaba
> Cc: 'Pgsql-General@Postgresql.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@zf.jcu.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.



pgsql-general by date:

Previous
From: 'Karel Zak'
Date:
Subject: Re: Removing OIDs without recreate
Next
From: Lonni Friedman
Date:
Subject: Re: vacuumdb is failing with NUMBER OF INDEX TUPLES NOT THE SAME AS HEAP