Thread: Table's OID
-----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-----
-----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-----
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
-----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-----