pgadmin error: ERROR: OID out of range

Поиск
Список
Период
Сортировка
От Rudi Schmitz
Тема pgadmin error: ERROR: OID out of range
Дата
Msg-id 92323da30906170854i1bbaf7d8h5ed4f98037b8d5f1@mail.gmail.com
обсуждение исходный текст
Ответы Re: pgadmin error: ERROR: OID out of range
Список 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 по дате отправления:

Предыдущее
От: Dear Rassawan
Дата:
Сообщение: PostgreSQL: Could you please help about script for triggering
Следующее
От: Dave Page
Дата:
Сообщение: Re: pgadmin error: ERROR: OID out of range