Обсуждение: Table's OID

Поиск
Список
Период
Сортировка

Table's OID

От
papapep
Дата:
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

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

How can I solve this?

Thanks in advance.

Josep Sànchez
[papapep]

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

iD8DBQE/3Zv+2vx52x0kyz4RAnA3AKDNb6k/5ZMA0bGJGokEZk1APKne0gCfUE42
l7pUt1q/KVMbZTnpA5g8gBQ=
=lBPV
-----END PGP SIGNATURE-----

Re: [personal] Re: Table's OID

От
papapep
Дата:
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

duncan adams wrote:
| still a novice myself but all i can say is that postgres recreates the
| oids when u redo the table, so never ever us the oids for anything, well
| i some times us them in pl/psql, but other then that never ever.

I haven't used it, it seems that it's the ODBC driver that it's using it...
In my reports I have never used them and, as far as I can, I won't use
them, but thanks for the advice.


Josep Sànchez
[papapep]
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQE/3Z902vx52x0kyz4RAlr6AKCqMABwy6nyq2KzFgn8LBxIHKq+6wCeIGkk
7ujBvXV4oz7FT4/r7FEqhYw=
=UU61
-----END PGP SIGNATURE-----

Re: Table's OID

От
Tom Lane
Дата:
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 ...

            regards, tom lane

Re: [personal] Re: Table's OID

От
papapep
Дата:
-----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-----