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/>
