pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / color / mirror / Atom feed
Help in finding the error 3+ messages / 2 participants [nested] [flat]
* Help in finding the error @ 2004-06-09 00:21 Duane Lee - EGOVX <DLee@mail.maricopa.gov> 2004-06-09 05:32 ` Re: [GENERAL] Help in finding the error Tom Lane <tgl@sss.pgh.pa.us> 0 siblings, 1 reply; 3+ messages in thread From: Duane Lee - EGOVX @ 2004-06-09 00:21 UTC (permalink / raw) To: PG General (E-mail) <pgsql-general@postgresql.org>; pgsql-admin 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 ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: [GENERAL] Help in finding the error 2004-06-09 00:21 Help in finding the error Duane Lee - EGOVX <DLee@mail.maricopa.gov> @ 2004-06-09 05:32 ` Tom Lane <tgl@sss.pgh.pa.us> 0 siblings, 0 replies; 3+ messages in thread From: Tom Lane @ 2004-06-09 05:32 UTC (permalink / raw) To: Duane Lee - EGOVX <DLee@mail.maricopa.gov>; +Cc: PG General (E-mail) <pgsql-general@postgresql.org>; 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 ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: [GENERAL] Help in finding the error @ 2004-06-09 18:31 Duane Lee - EGOVX <DLee@mail.maricopa.gov> 0 siblings, 0 replies; 3+ messages in thread From: Duane Lee - EGOVX @ 2004-06-09 18:31 UTC (permalink / raw) To: 'Tom Lane' <tgl@sss.pgh.pa.us>; Duane Lee - EGOVX <DLee@mail.maricopa.gov>; +Cc: PG General (E-mail) <pgsql-general@postgresql.org>; pgsql-admin 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 <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 ^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2004-06-09 18:31 UTC | newest] Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2004-06-09 00:21 Help in finding the error Duane Lee - EGOVX <DLee@mail.maricopa.gov> 2004-06-09 05:32 ` Tom Lane <tgl@sss.pgh.pa.us> 2004-06-09 18:31 Re: [GENERAL] Help in finding the error Duane Lee - EGOVX <DLee@mail.maricopa.gov>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox