Help in finding the error

[Duane Lee - EGOVX]

I'm trying to insert data into an empty table but I keep getting the error:

ERROR: could not open relation with OID 42939

I have a couple of constraints on the table but what I'm entering doesn't
violate those. Can someone tell me where in the system catalog I can look
to find what relation it is talking about?

TIA,
Duane

[Tom Lane]

Duane Lee - EGOVX <DL**@mail.maricopa.gov> writes:

I'm trying to insert data into an empty table but I keep getting the error:
ERROR: could not open relation with OID 42939
More detail please? For starters, what PG version is this?
I have a couple of constraints on the table but what I'm entering doesn't
violate those.

My crudest guesses would involve rules not constraints (specifically,
a rule that references a no-longer-extant table).

regards, tom lane

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

[Tom Lane]

Duane Lee - EGOVX <DL**@mail.maricopa.gov> writes:

I'm trying to insert data into an empty table but I keep getting the error:
ERROR: could not open relation with OID 42939
More detail please? For starters, what PG version is this?
I have a couple of constraints on the table but what I'm entering doesn't
violate those.

My crudest guesses would involve rules not constraints (specifically,
a rule that references a no-longer-extant table).

regards, tom lane

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