Skip site navigation (1) Skip section navigation (2)

Restore OIDs

From: "Marcin Kuk" <marcin(dot)kuk(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Restore OIDs
Date: 2006-04-26 10:51:03
Message-ID: 28d670ae0604260351s16ea3bf0x36aadb40d6c500ec@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-admin
Hi

I have huge problem.
Since 8.1 PostgreSQL don't make an OIDs by default.
I dumped my database from v7.4 and move into v8.1.
I didn't see any errors so it seems to be correct.
If I tried to use database I realise that database have not OID's.
Is any solution to add the OID's into this database after setting
default_with_oids=true.
I don't have time inserting all database again.

I'm not subscribed.
Please CC to me: marcin(dot)kuk(at)gmail(dot)com

Marcin Kuk

pgsql-admin by date

Next:From: AndyDate: 2006-04-26 11:49:26
Subject: Re: Database LATIN1 to UFT-8 (unicode) converting problem SOLVED
Previous:From: sandhyaDate: 2006-04-26 10:46:59
Subject: Problem with Large objects of .gif&.asp

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group