From DLee@mail.maricopa.gov Wed Jun 9 00:22:16 2004 X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 90F99D1B1E0; Tue, 8 Jun 2004 21:22:16 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 75069-01; Wed, 9 Jun 2004 00:22:14 +0000 (GMT) Received: from mailbox.maricopa.gov (mailbox.maricopa.gov [156.42.4.109]) by svr1.postgresql.org (Postfix) with ESMTP id F1962D1B1D2; Tue, 8 Jun 2004 21:22:08 -0300 (ADT) Received: from maricopa_xcng2.maricopa.gov (maricopa_xcng2.maricopa.gov [156.42.103.174] (may be forged)) by mailbox.maricopa.gov (8.8.6 (PHNE_17190)/8.8.6) with ESMTP id RAA11378; Tue, 8 Jun 2004 17:15:32 -0700 (MST) Received: by maricopa_xcng2 with Internet Mail Service (5.5.2657.72) id ; Tue, 8 Jun 2004 17:22:09 -0700 Message-ID: <64EDC403A1417B4299488BAE87CA7CBF01CD0E65@maricopa_xcng0> From: Duane Lee - EGOVX To: "PG General (E-mail)" , "PGADMIN (E-mail)" Subject: Help in finding the error Date: Tue, 8 Jun 2004 17:21:58 -0700 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2657.72) Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C44DB7.C6ED2240" X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.8 tagged_above=0.0 required=5.0 tests=HTML_30_40, HTML_MESSAGE X-Spam-Level: X-Archive-Number: 200406/96 X-Sequence-Number: 13756 This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01C44DB7.C6ED2240 Content-Type: text/plain; charset="iso-8859-1" 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 ------_=_NextPart_001_01C44DB7.C6ED2240 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Help in finding the error

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 syst= em catalog I can look to find what relation it is talking about?

TIA,
Duane

------_=_NextPart_001_01C44DB7.C6ED2240-- From tgl@sss.pgh.pa.us Wed Jun 9 05:32:13 2004 X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id E23EAD1B20F; Wed, 9 Jun 2004 02:32:13 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 91299-04; Wed, 9 Jun 2004 05:32:09 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id 39A2ED1B1EC; Wed, 9 Jun 2004 02:32:06 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.11/8.12.11) with ESMTP id i595W5FG016356; Wed, 9 Jun 2004 01:32:05 -0400 (EDT) To: Duane Lee - EGOVX Cc: "PG General (E-mail)" , "PGADMIN (E-mail)" Subject: Re: [GENERAL] Help in finding the error In-reply-to: <64EDC403A1417B4299488BAE87CA7CBF01CD0E65@maricopa_xcng0> References: <64EDC403A1417B4299488BAE87CA7CBF01CD0E65@maricopa_xcng0> Comments: In-reply-to Duane Lee - EGOVX message dated "Tue, 08 Jun 2004 17:21:58 -0700" Date: Wed, 09 Jun 2004 01:32:04 -0400 Message-ID: <16355.1086759124@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200406/100 X-Sequence-Number: 13760 Duane Lee - EGOVX 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 DLee@mail.maricopa.gov Wed Jun 9 18:32:46 2004 X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id E8A8ED1B3A7; Wed, 9 Jun 2004 15:32:46 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 67700-02; Wed, 9 Jun 2004 18:32:35 +0000 (GMT) Received: from mailbox.maricopa.gov (mailbox.maricopa.gov [156.42.4.109]) by svr1.postgresql.org (Postfix) with ESMTP id DD826D1B37B; Wed, 9 Jun 2004 15:31:33 -0300 (ADT) Received: from maricopa_xcng2.maricopa.gov (maricopa_xcng2.maricopa.gov [156.42.103.174] (may be forged)) by mailbox.maricopa.gov (8.8.6 (PHNE_17190)/8.8.6) with ESMTP id LAA15828; Wed, 9 Jun 2004 11:24:41 -0700 (MST) Received: by maricopa_xcng2 with Internet Mail Service (5.5.2657.72) id ; Wed, 9 Jun 2004 11:31:23 -0700 Message-ID: <64EDC403A1417B4299488BAE87CA7CBF01CD0E67@maricopa_xcng0> From: Duane Lee - EGOVX To: "'Tom Lane'" , Duane Lee - EGOVX Cc: "PG General (E-mail)" , "PGADMIN (E-mail)" Subject: Re: [GENERAL] Help in finding the error Date: Wed, 9 Jun 2004 11:31:19 -0700 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2657.72) Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C44E4F.F522FBB0" X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.5 tagged_above=0.0 required=5.0 tests=HTML_20_30, HTML_MESSAGE X-Spam-Level: X-Archive-Number: 200406/123 X-Sequence-Number: 13783 This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01C44E4F.F522FBB0 Content-Type: text/plain; charset="iso-8859-1" I'm on 7.4.2. I did some more testing and ended up dropping and recreating the table with all the constraints, etc. in the definition and tried my inserts, INSERT...SELECT..., and it worked just fine. I probably had something else set that I didn't want set that was causing my problems. But still, I would like to know where I might go in the catalog to find the info about "relation with OID xxxx". For the most part I'll chalk up my problem to my lack of experience with Postgres. All in all I'm impressed with what it can do having come from a DB2 on the mainframe background. Thanks, Duane -----Original Message----- From: Tom Lane [mailto:tgl@sss.pgh.pa.us] Sent: Tuesday, June 08, 2004 10:32 PM To: Duane Lee - EGOVX Cc: PG General (E-mail); PGADMIN (E-mail) Subject: Re: [GENERAL] Help in finding the error Duane Lee - EGOVX 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 ------_=_NextPart_001_01C44E4F.F522FBB0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable RE: [GENERAL] Help in finding the error

I'm on 7.4.2.  I did some more testing and ended up = dropping and recreating the table with all the constraints, etc. in the def= inition and tried my inserts, INSERT...SELECT..., and it worked just fine.&= nbsp; I probably had something else set that I didn't want set that was cau= sing my problems.  But still, I would like to know where I might go in= the catalog to find the info about "relation with OID xxxx".

For the most part I'll chalk up my problem to my lack of = experience with Postgres.  All in all I'm impressed with what it can d= o having come from a DB2 on the mainframe background.

Thanks,
Duane

-----Original Message-----
From: Tom Lane [mai= lto:tgl@sss.pgh.pa.us]
Sent: Tuesday, June 08, 2004 10:32 PM
To: Duane Lee - EGOVX
Cc: PG General (E-mail); PGADMIN (E-mail)
Subject: Re: [GENERAL] Help in finding the error


Duane Lee - EGOVX <DLee@mail.maricopa.gov> writes:<= /FONT>
> 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 i= s 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 (s= pecifically,
a rule that references a no-longer-extant table).

             = ;           reg= ards, tom lane

------_=_NextPart_001_01C44E4F.F522FBB0--