Re: [GENERAL] Help in finding the error - Mailing list pgsql-admin

From Tom Lane
Subject Re: [GENERAL] Help in finding the error
Date
Msg-id 16355.1086759124@sss.pgh.pa.us
Whole thread Raw
In response to Help in finding the error  (Duane Lee - EGOVX <DLee@mail.maricopa.gov>)
List pgsql-admin
Duane Lee - EGOVX <DLee@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

pgsql-admin by date:

Previous
From: Dan Thompson
Date:
Subject: Re: createuser error
Next
From: Peter Eisentraut
Date:
Subject: Re: Training