Table's OID

#1

-----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:

Quote:

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-----

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

#2

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

duncan adams wrote:

Quote:

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+6w CeIGkk
7ujBvXV4oz7FT4/r7FEqhYw=
=UU61
-----END PGP SIGNATURE-----

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo (AT) postgresql (DOT) org

#3

papapep <papapep (AT) gmx (DOT) net> writes:

Quote:

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

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo (AT) postgresql (DOT) org so that your
message can get through to the mailing list cleanly

#4

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Tom Lane wrote:

Quote:

papapep <papapep (AT) gmx (DOT) 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+5wIWmvdg Cgtw/i
nufUzJDFauM2Pl5hhlYEDcE=
=dNyr
-----END PGP SIGNATURE-----

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Table's OID

comp.databases.postgresql.novice comp.databases.postgresql.novice

Table's OID - 12-15-2003 , 05:33 AM

Re: [personal] Re: Table's OID - 12-15-2003 , 05:48 AM

Re: Table's OID - 12-15-2003 , 10:12 AM

Re: [personal] Re: Table's OID - 12-15-2003 , 12:18 PM