Re: Altering existing table to be WITHOUT OIDs

On Sat, 2002-05-25 at 15:17, Doug Fields wrote:
> For the benefit for anyone who may search this list in the future for this 
> information, I used the following queries to implement Tom's suggestion on 
> the table "list_entries" in this example:
> 
> UPDATE pg_class SET relhasoids=false WHERE relname='list_entries';
> DELETE FROM pg_attribute
>      WHERE attrelid = (SELECT oid FROM pg_class WHERE relname = 
> 'list_entries')
>          AND attname='oid';
> 
> You might want to also include the reltype in the sub-SELECT if you re-use 
> names willy-nilly.
Thanks Doug.  Worked great for a table I forgot to include the WITHOUT
OIDS option on.  (gets 4-5000 rows every 5 minutes :-) ). 


> 
> Cheers,
> 
> Doug
> 
> 
> At 04:06 PM 5/24/2002, Tom Lane wrote:
> >Doug Fields  writes:
> > > The documentation does not give any information about how I might do this
> > > in the ALTER TABLE, so it may not be possible, at least, not that way.
> >
> >ALTER TABLE doesn't support it, but you could reach in and tweak
> >pg_class.relhasoids for your tables.  I think you would also need to
> >delete the pg_attribute row for oid for each such table if you wanted
> >to have a perfectly clean result.
> >
> >                         regards, tom lane
> 
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
> 
> http://archives.postgresql.org
> 
-- 
Larry Rosenman                     http://www.lerctr.org/~ler
Phone: +1 972-414-9812                 E-Mail: ler@lerctr.org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749