Re: [personal] Re: Table's OID

Поиск
Список
Период
Сортировка
От papapep
Тема Re: [personal] Re: Table's OID
Дата
Msg-id 3FDDFAEB.2020006@gmx.net
обсуждение исходный текст
Ответ на Re: Table's OID  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Headr files
Следующее
От: Oliver Fromme
Дата:
Сообщение: Another HA idea :-)