Re: [personal] Re: Table's OID - Mailing list pgsql-novice

From papapep
Subject Re: [personal] Re: Table's OID
Date
Msg-id 3FDDFAEB.2020006@gmx.net
Whole thread Raw
In response to Re: Table's OID  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-novice
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Tom Lane wrote:
| papapep <papapep@gmx.net> writes:
|
|>How can I modify a table OID? I deleted and recreated a table and now
|>when I try to run my reports (with Cognos Impromptu) it says:
|
|
|>| ERROR:  Relation "control_flota" with OID 36775365 no longer exists
|
|
| You probably need to recreate some view that refers to that table.
|
| BTW, if you were running PG 7.3 or 7.4, it'd not have let you get into
| this position.  Think about updating ...

It has worked. Many, many, many, many ^n thanks for your help.

By the way, any upgrading tutorial (I'm really scared of triyng to do it...)

Josep Sànchez
[papapep]

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQE/3frq2vx52x0kyz4RAho6AJ9MKD29MXmkySTZ30vbt+5wIWmvdgCgtw/i
nufUzJDFauM2Pl5hhlYEDcE=
=dNyr
-----END PGP SIGNATURE-----




pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: Headr files
Next
From: Oliver Fromme
Date:
Subject: Another HA idea :-)