Postgresql Server is 8.3.7.1 on centos5.3. I got to 8..3.7.1 postgresql by
using rpm from here on a centos 5.3 installation
http://yum.pgsqlrpms.org/reporpms/repoview/pgdg-centos.html
I install server and pgadmin, then adminpack.sql against postgres, then
run against postgres db
CREATE TRUSTED PROCEDURAL LANGUAGE 'plpgsql'
HANDLER plpgsql_call_handler
VALIDATOR plpgsql_validator;
then run pgagent.sql against postgres.
PROBLEM: When I click on certain parts in pgadmin if I have the dependencies
tab selected I get OID out of range error that pops up. Is this just an
annoyance with the GUI that i can't display this info or is my setup
incorrect for pgagent?
It only starts showing up after I install pgagent. Here is a log for pgadmin
set at debug level. In it with Dependencies selected on the right, I clicked
on Catalogs under postgresql I got no errors. Then I click on Jobs I get OID
out of range error. Everything seems to be working fine otherwise. Jobs run
fine.
LOG:
2009-06-17 10:35:06 INFO : Displaying properties for Catalogs Catalogs
2009-06-17 10:35:06 STATUS : Retrieving Catalogs details...
2009-06-17 10:35:06 STATUS : Retrieving Catalogs details... (0.01 secs)
2009-06-17 10:35:06 QUERY : Set query (127.0.0.1:5432): SELECT DISTINCT
deptype, refclassid, cl.relkind,
CASE WHEN cl.relkind IS NOT NULL THEN cl.relkind ||
COALESCE(dep.refobjsubid::text, '')
WHEN tg.oid IS NOT NULL THEN 'T'::text
WHEN ty.oid IS NOT NULL THEN 'y'::text
WHEN ns.oid IS NOT NULL THEN 'n'::text
WHEN pr.oid IS NOT NULL THEN 'p'::text
WHEN la.oid IS NOT NULL THEN 'l'::text
WHEN rw.oid IS NOT NULL THEN 'R'::text
WHEN co.oid IS NOT NULL THEN 'C'::text || contype
ELSE '' END AS type,
COALESCE(coc.relname, clrw.relname) AS ownertable,
COALESCE(cl.relname || '.' || att.attname, cl.relname, conname,
proname, tgname, typname, lanname, rulename, ns.nspname) AS refname,
COALESCE(nsc.nspname, nso.nspname, nsp.nspname, nst.nspname,
nsrw.nspname) AS nspname
FROM pg_depend dep
LEFT JOIN pg_class cl ON dep.refobjid=cl.oid
LEFT JOIN pg_attribute att ON dep.refobjid=att.attrelid AND
dep.refobjsubid=att.attnum L
2009-06-17 10:35:08 QUERY : Set query (127.0.0.1:5432): SELECT rolname AS
refname, refclassid, deptype
FROM pg_shdepend dep
LEFT JOIN pg_roles r ON refclassid=1260 AND refobjid=r.oid
WHERE dep.objid=0::oid
ORDER BY 1
2009-06-17 10:35:10 INFO : Displaying properties for Jobs Jobs
2009-06-17 10:35:10 STATUS : Retrieving Jobs details...
2009-06-17 10:35:10 QUERY : Set query (127.0.0.1:5432): SELECT j.*, cl.*,
ag.*, sub.jlgstatus AS joblastresult FROM pgagent.pga_job j JOIN
pgagent.pga_jobclass cl ON cl.jclid=jobjclid LEFT OUTER JOIN
pgagent.pga_jobagent ag ON ag.jagpid=jobagentid LEFT OUTER JOIN (SELECT
DISTINCT ON (jlgjobid) jlgstatus, jlgjobid FROM pgagent.pga_joblog ORDER
BY jlgjobid, jlgid desc) sub ON sub.jlgjobid = j.jobid ORDER BY jobname;
2009-06-17 10:35:10 STATUS : Retrieving Jobs details... (0.02 secs)
2009-06-17 10:35:10 QUERY : Set query (127.0.0.1:5432): SELECT DISTINCT
deptype, refclassid, cl.relkind,
CASE WHEN cl.relkind IS NOT NULL THEN cl.relkind ||
COALESCE(dep.refobjsubid::text, '')
WHEN tg.oid IS NOT NULL THEN 'T'::text
WHEN ty.oid IS NOT NULL THEN 'y'::text
WHEN ns.oid IS NOT NULL THEN 'n'::text
WHEN pr.oid IS NOT NULL THEN 'p'::text
WHEN la.oid IS NOT NULL THEN 'l'::text
WHEN rw.oid IS NOT NULL THEN 'R'::text
WHEN co.oid IS NOT NULL THEN 'C'::text || contype
ELSE '' END AS type,
COALESCE(coc.relname, clrw.relname) AS ownertable,
COALESCE(cl.relname || '.' || att.attname, cl.relname, conname,
proname, tgname, typname, lanname, rulename, ns.nspname) AS refname,
COALESCE(nsc.nspname, nso.nspname, nsp.nspname, nst.nspname,
nsrw.nspname) AS nspname
FROM pg_depend dep
LEFT JOIN pg_class cl ON dep.refobjid=cl.oid
LEFT JOIN pg_attribute att ON dep.refobjid=att.attrelid AND
dep.refobjsubid=att.attnum L
2009-06-17 10:35:10 ERROR : ERROR: OID out of range
2009-06-17 10:35:12 QUERY : Set query (127.0.0.1:5432): SELECT rolname AS
refname, refclassid, deptype
FROM pg_shdepend dep
LEFT JOIN pg_roles r ON refclassid=1260 AND refobjid=r.oid
WHERE dep.objid=7664952187699019109::oid
ORDER BY 1
2009-06-17 10:35:12 ERROR : ERROR: OID out of range
