pgadmin error: ERROR: OID out of range - Mailing list pgadmin-support
From | Rudi Schmitz |
---|---|
Subject | pgadmin error: ERROR: OID out of range |
Date | |
Msg-id | 92323da30906170854i1bbaf7d8h5ed4f98037b8d5f1@mail.gmail.com Whole thread Raw |
Responses |
Re: pgadmin error: ERROR: OID out of range
|
List | pgadmin-support |
Postgresql Server is 8.3.7.1 on centos5.3. I got to 8..3.7.1 postgresql by using <span style="font-size: 12pt; font-family:"Times New Roman","serif";">rpm from here on a centos 5.3 installation <a href="http://yum.pgsqlrpms.org/reporpms/repoview/pgdg-centos.html">http://yum.pgsqlrpms.org/reporpms/repoview/pgdg-centos.html</a><br style=""/></span><br />I install server and pgadmin, then adminpack.sql against postgres, then <br /><br />run against postgresdb<br /><br />CREATE TRUSTED PROCEDURAL LANGUAGE 'plpgsql'<br /> HANDLER plpgsql_call_handler<br /> VALIDATORplpgsql_validator;<br /><br />then run pgagent.sql against postgres.<br /><br />PROBLEM: When I click on certainparts in pgadmin if I have the dependencies tab selected I get OID out of range error that pops up. Is this just anannoyance with the GUI that i can't display this info or is my setup incorrect for pgagent?<br /> It only starts showingup after I install pgagent. Here is a log for pgadmin set at debug level. In it with Dependencies selected on theright, I clicked on Catalogs under postgresql I got no errors. Then I click on Jobs I get OID out of range error. Everythingseems to be working fine otherwise. Jobs run fine. <br /><br /><br />LOG:<br /><br />2009-06-17 10:35:06 INFO : Displaying properties for Catalogs Catalogs<br />2009-06-17 10:35:06 STATUS : Retrieving Catalogs details...<br />2009-06-1710:35:06 STATUS : Retrieving Catalogs details... (0.01 secs)<br /> 2009-06-17 10:35:06 QUERY : Set query (<ahref="http://127.0.0.1:5432">127.0.0.1:5432</a>): SELECT DISTINCT deptype, refclassid, cl.relkind,<br /> CASE WHENcl.relkind IS NOT NULL THEN cl.relkind || COALESCE(dep.refobjsubid::text, '')<br /> WHEN tg.oid IS NOT NULLTHEN 'T'::text<br /> WHEN ty.oid IS NOT NULL THEN 'y'::text<br /> WHEN ns.oid IS NOT NULL THEN'n'::text<br /> WHEN pr.oid IS NOT NULL THEN 'p'::text<br /> WHEN la.oid IS NOT NULL THEN 'l'::text<br/> WHEN rw.oid IS NOT NULL THEN 'R'::text<br /> WHEN co.oid IS NOT NULL THEN 'C'::text|| contype<br /> ELSE '' END AS type,<br /> COALESCE(coc.relname, clrw.relname) AS ownertable,<br/> COALESCE(cl.relname || '.' || att.attname, cl.relname, conname, proname, tgname, typname, lanname,rulename, ns.nspname) AS refname,<br /> COALESCE(nsc.nspname, nso.nspname, nsp.nspname, nst.nspname, nsrw.nspname)AS nspname<br /> FROM pg_depend dep<br /> LEFT JOIN pg_class cl ON dep.refobjid=cl.oid<br /> LEFT JOIN pg_attributeatt ON dep.refobjid=att.attrelid AND dep.refobjsubid=att.attnum L<br />2009-06-17 10:35:08 QUERY : Set query(<a href="http://127.0.0.1:5432">127.0.0.1:5432</a>): SELECT rolname AS refname, refclassid, deptype<br /> FROM pg_shdependdep<br /> LEFT JOIN pg_roles r ON refclassid=1260 AND refobjid=r.oid<br /> WHERE dep.objid=0::oid<br /> ORDERBY 1<br />2009-06-17 10:35:10 INFO : Displaying properties for Jobs Jobs<br />2009-06-17 10:35:10 STATUS : RetrievingJobs details...<br /> 2009-06-17 10:35:10 QUERY : Set query (<a href="http://127.0.0.1:5432">127.0.0.1:5432</a>):SELECT j.*, cl.*, ag.*, sub.jlgstatus AS joblastresult FROM pgagent.pga_jobj JOIN pgagent.pga_jobclass cl ON cl.jclid=jobjclid LEFT OUTER JOIN pgagent.pga_jobagent ag ON ag.jagpid=jobagentidLEFT OUTER JOIN (SELECT DISTINCT ON (jlgjobid) jlgstatus, jlgjobid FROM pgagent.pga_joblog ORDERBY jlgjobid, jlgid desc) sub ON sub.jlgjobid = j.jobid ORDER BY jobname;<br /> 2009-06-17 10:35:10 STATUS : RetrievingJobs details... (0.02 secs)<br />2009-06-17 10:35:10 QUERY : Set query (<a href="http://127.0.0.1:5432">127.0.0.1:5432</a>):SELECT DISTINCT deptype, refclassid, cl.relkind,<br /> CASE WHEN cl.relkindIS NOT NULL THEN cl.relkind || COALESCE(dep.refobjsubid::text, '')<br /> WHEN tg.oid IS NOT NULL THEN'T'::text<br /> WHEN ty.oid IS NOT NULL THEN 'y'::text<br /> WHEN ns.oid IS NOT NULL THEN 'n'::text<br/> WHEN pr.oid IS NOT NULL THEN 'p'::text<br /> WHEN la.oid IS NOT NULL THEN 'l'::text<br/> WHEN rw.oid IS NOT NULL THEN 'R'::text<br /> WHEN co.oid IS NOT NULL THEN 'C'::text|| contype<br /> ELSE '' END AS type,<br /> COALESCE(coc.relname, clrw.relname) AS ownertable,<br/> COALESCE(cl.relname || '.' || att.attname, cl.relname, conname, proname, tgname, typname, lanname,rulename, ns.nspname) AS refname,<br /> COALESCE(nsc.nspname, nso.nspname, nsp.nspname, nst.nspname, nsrw.nspname)AS nspname<br /> FROM pg_depend dep<br /> LEFT JOIN pg_class cl ON dep.refobjid=cl.oid<br /> LEFT JOIN pg_attributeatt ON dep.refobjid=att.attrelid AND dep.refobjsubid=att.attnum L<br />2009-06-17 10:35:10 ERROR : ERROR: OID out of range<br /><br />2009-06-17 10:35:12 QUERY : Set query (<a href="http://127.0.0.1:5432">127.0.0.1:5432</a>):SELECT rolname AS refname, refclassid, deptype<br /> FROM pg_shdepend dep<br/> LEFT JOIN pg_roles r ON refclassid=1260 AND refobjid=r.oid<br /> WHERE dep.objid=7664952187699019109::oid<br /> ORDERBY 1<br />2009-06-17 10:35:12 ERROR : ERROR: OID out of range<br /><br /><br /><br /><br /><br /><br /><br /><br/>
pgadmin-support by date: