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 <dfields-pg-general(at)pexicom(dot)com> 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(at)lerctr(dot)org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749