|
Home > Archive > PostgreSQL Administration > January 2006 > OIDS problem
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
| Szabolcs BALLA 2006-01-13, 7:23 am |
| Hi,
I have already upgraded our server from 7.4 to 8.1.
My problem is the next: some of our queries use OIDS but I restored the
databases without OIDS.
Is it possible to set the OIDS without dump and restore?
Thanks
Szabek
| |
| Jim C. Nasby 2006-01-13, 8:24 pm |
| On Fri, Jan 13, 2006 at 11:05:38AM +0100, Szabolcs BALLA wrote:
> Hi,
>
> I have already upgraded our server from 7.4 to 8.1.
> My problem is the next: some of our queries use OIDS but I restored the
> databases without OIDS.
> Is it possible to set the OIDS without dump and restore?
No; the tables are now missing the OID fields. You'll need to dump and
restore. You should also change your application... IIRC the intention
is to eventually remove OIDs from user tables.
--
Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
| |
| Tom Lane 2006-01-13, 8:24 pm |
| "Jim C. Nasby" <jnasby@pervasive.com> writes:
> You should also change your application... IIRC the intention
> is to eventually remove OIDs from user tables.
There is no such plan --- defaulting to WITHOUT OIDS is as far as we
intend to go.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
|
|
|
|
|