| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Duane Lee - EGOVX <DLee(at)mail(dot)maricopa(dot)gov> |
| Cc: | "PG General (E-mail)" <pgsql-general(at)postgresql(dot)org>, "PGADMIN (E-mail)" <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: [GENERAL] Help in finding the error |
| Date: | 2004-06-09 05:32:04 |
| Message-ID: | 16355.1086759124@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-general |
Duane Lee - EGOVX <DLee(at)mail(dot)maricopa(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Eisentraut | 2004-06-09 06:41:20 | Re: Training |
| Previous Message | Cook, Tom | 2004-06-09 05:11:28 | PostgreSQL 7.4.2 on SunOS 4.1.4 |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Henrik Steffen | 2004-06-09 07:00:31 | index with LIKE |
| Previous Message | Scott Marlowe | 2004-06-09 04:39:35 | Another win for PostgreSQL |