-->-----Mensagem original-----
-->De: [EMAIL PROTECTED]
-->[mailto:[EMAIL PROTECTED] Em nome de Dave Page
-->Enviada em: quinta-feira, 9 de novembro de 2006 06:14
-->Para: Alejandro Michelin Salomon ( Adinet )
-->Cc: Pgadmin-Support
-->Assunto: Re: [pgadmin-support] PG Admin III crash when
-->inserting row in view
-->
-->
-->Alejandro Michelin Salomon ( Adinet ) wrote:
-->> Hi :
-->>
-->> Plataform : windows XP SP2.
-->> Language : Englihs
-->> Installation Binary, from windows installer ( Downloaded file
-->> pgadmin3-1.6.0-beta3.zip )
-->>
-->> Vercion : 1.6 Beta 3 ( Oct 12 2006, rev: 5475 )
-->>
-->>
-->> Problem :
-->>
-->> I has a table width 5 fields.
-->>
-->> -- hd_tecnicos
-->> CREATE SEQUENCE hd_tecnicos_idtecnico_seq;
-->> CREATE TABLE hd_tecnicos
-->> (
-->> idtecnico int4 NOT NULL DEFAULT
-->> nextval('hd_tecnicos_idtecnico_seq'::text),
-->> idempresa int4 NOT NULL DEFAULT 0,
-->> ativo int2 NOT NULL DEFAULT 0,
-->> idusuario int4 NOT NULL DEFAULT 0, -- Usuário do sistema.
-->> idpessoa int4 NOT NULL DEFAULT 0, -- Número pessoa para
-->poder criar as
-->> contas a pagar.
-->> CONSTRAINT hd_tecnicos_PK PRIMARY KEY (idempresa, idusuario)
-->> )
-->> WITHOUT OIDS;
-->>
-->> INSERT INTO hd_tecnicos( idempresa, ativo, idusuario )
-->VALUES ( 1, 1,
-->> 1); INSERT INTO hd_tecnicos( idempresa, ativo, idusuario )
-->VALUES ( 1,
-->> 1, 2); INSERT INTO hd_tecnicos( idempresa, ativo,
-->idusuario ) VALUES (
-->> 1, 1, 3); INSERT INTO hd_tecnicos( idempresa, ativo, idusuario )
-->> VALUES ( 1, 1, 4); INSERT INTO hd_tecnicos( idempresa, ativo,
-->> idusuario ) VALUES ( 1, 1, 5); INSERT INTO hd_tecnicos( idempresa,
-->> ativo, idusuario ) VALUES ( 1, 1, 6); INSERT INTO hd_tecnicos(
-->> idempresa, ativo, idusuario ) VALUES ( 1, 1, 9); This table has 7
-->> records.
-->>
-->> I open the view window. To see the rows from hd_tecnicos.
-->>
-->> I the row mark as '*' i type :
-->>
-->> Value 1 for idempresa, value 1 for ativo, value 13 for idusuario.
-->>
-->> Note :
-->> For the colummn idtecnico i dont fill width data becouse the
-->> nextval('hd_tecnicos_idtecnico_seq'::text) has to get the
-->> next valueand fill them.
-->> When i am in the column idusuario and press enter pgadmin crashes.
-->>
-->> I dont have a error reporting becouse is a binary installation.
-->
-->This works perfectly for me in RC2, which does include a bug
-->fix related
-->to primary keys that aren't in the first columns. Can you try that
-->version please: http://www.pgadmin.org/download/windows.php
-->
-->If that crashes for you as well, can you switch on logging
-->to "Errors,
-->Notices, SQL" under File -> Options -> Logging, recreate the
-->crash, and
-->then send the logfile please?
-->
-->Regards, Dave
-->
-->---------------------------(end of
-->broadcast)---------------------------
-->TIP 4: Have you searched our list archives?
-->
--> http://archives.postgresql.org
-->
Dave :
I download and install the pgadmin 1.6 rc2, i use the upgrade.bat to
install.
The crahes still happening.
I configured my pgadmin with File -> Options -> Logging ( Error, Notices,
Sql ).
I attach to this mail amichelin1.log file with the crash log.
Alejandro.
2006-11-09 09:35:07 INFO : Setting loglevel to: Errors, Notices, &SQL
2006-11-09 09:35:11 STATUS : Retrieving server properties...
2006-11-09 09:35:11 STATUS : Retrieving server properties... (0,00 secs)
2006-11-09 09:35:12 STATUS : Connecting to database...
2006-11-09 09:35:12 QUERY : Set query (localhost:5432): SET
DateStyle=ISO;SELECT oid, pg_encoding_to_char(encoding) AS encoding,
datlastsysoid
FROM pg_database WHERE datname='helpdesk'
2006-11-09 09:35:12 QUERY : Scalar query (localhost:5432): SELECT version();
2006-11-09 09:35:12 QUERY : Query result: PostgreSQL 8.0.8 on i686-pc-mingw32,
compiled by GCC gcc.exe (GCC) 3.4.2 (mingw-special)
2006-11-09 09:35:12 QUERY : Set query (localhost:5432): SELECT proname,
pronargs, proargtypes[0] AS arg0, proargtypes[1] AS arg1, proargtypes[2] AS arg2
FROM pg_proc
JOIN pg_namespace n ON n.oid=pronamespace
WHERE proname IN ('pg_tablespace_size', 'pg_file_read', 'pg_logfile_rotate',
'pg_postmaster_starttime', 'pg_terminate_backend', 'pg_reload_conf')
AND nspname IN ('pg_catalog', 'public')
2006-11-09 09:35:12 QUERY : Set query (localhost:5432): SELECT usecreatedb,
usesuper
FROM pg_user WHERE usename=current_user
2006-11-09 09:35:12 STATUS : Connecting to database... (0,14 secs)
2006-11-09 09:35:12 STATUS : Restoring previous environment...
2006-11-09 09:35:12 QUERY : Set query (localhost:5432): SELECT db.oid,
datname, spcname, datallowconn, datconfig, datacl,
pg_encoding_to_char(encoding) AS serverencoding, pg_get_userbyid(datdba) AS
datowner,has_database_privilege(db.oid, 'CREATE') as cancreate
FROM pg_database db
LEFT OUTER JOIN pg_tablespace ta ON db.dattablespace=ta.OID
ORDER BY datname
2006-11-09 09:35:12 QUERY : Set query (localhost:5432): SELECT ts.oid,
spcname, spclocation, pg_get_userbyid(spcowner) as spcuser, spcacl FROM
pg_tablespace ts
ORDER BY spcname
2006-11-09 09:35:12 QUERY : Scalar query (localhost:5432): SELECT cl.oid FROM
pg_class cl JOIN pg_namespace ns ON ns.oid=relnamespace
WHERE relname='pga_job' AND nspname='pgagent'
2006-11-09 09:35:12 QUERY : Set query (localhost:5432): SELECT * from pg_group
ORDER BY groname
2006-11-09 09:35:12 QUERY : Scalar query (localhost:5432): SELECT
has_table_privilege('pg_shadow', 'SELECT')
2006-11-09 09:35:12 QUERY : Query result: f
2006-11-09 09:35:12 QUERY : Set query (localhost:5432): SELECT * FROM pg_user
ORDER BY usename
2006-11-09 09:35:12 QUERY : Set query (localhost:5432): SELECT setting FROM
pg_settings
WHERE name IN ('autovacuum', 'stats_start_collector', 'stats_row_level')
2006-11-09 09:35:12 QUERY : Scalar query (localhost:5432): SELECT description
FROM pg_description WHERE objoid=6205160::oid
2006-11-09 09:35:12 QUERY : Scalar query (localhost:5432): SELECT proname FROM
pg_proc WHERE proname='pg_get_viewdef' AND proargtypes[1]=16
2006-11-09 09:35:12 QUERY : Query result: pg_get_viewdef
2006-11-09 09:35:12 QUERY : Scalar query (localhost:5432): SHOW search_path
2006-11-09 09:35:12 QUERY : Query result: $user,public
2006-11-09 09:35:12 QUERY : Set query (localhost:5432): SELECT nspname,
session_user=nspname AS isuser FROM pg_namespace
2006-11-09 09:35:12 QUERY : Set query (localhost:5432): SELECT ca.oid, ca.*,
format_type(st.oid,NULL) AS srctyp, format_type(tt.oid,tt.typtypmod) AS trgtyp,
ns.nspname AS srcnspname, nt.nspname AS trgnspname,
proname, np.nspname AS pronspname, description
FROM pg_cast ca
JOIN pg_type st ON st.oid=castsource
JOIN pg_namespace ns ON ns.oid=st.typnamespace
JOIN pg_type tt ON tt.oid=casttarget
JOIN pg_namespace nt ON nt.oid=tt.typnamespace
LEFT JOIN pg_proc pr ON pr.oid=castfunc
LEFT JOIN pg_namespace np ON np.oid=pr.pronamespace
LEFT OUTER JOIN pg_description des ON des.objoid=ca.oid AND des.objsubid=0
ORDER BY st.typname, tt.typname
2006-11-09 09:35:12 QUERY : Set query (localhost:5432): SELECT lan.oid,
lan.lanname, lanpltrusted, lanacl, hp.proname as lanproc, vp.proname as lanval,
description
FROM pg_language lan
JOIN pg_proc hp on hp.oid=lanplcallfoid
LEFT OUTER JOIN pg_proc vp on vp.oid=lanvalidator
LEFT OUTER JOIN pg_description des ON des.objoid=lan.oid AND des.objsubid=0
WHERE lanispl IS TRUE
ORDER BY lanname
2006-11-09 09:35:12 QUERY : Set query (localhost:5432): SELECT CASE WHEN
nspname LIKE 'pg\_temp\_%%' THEN 1
WHEN (nspname LIKE 'pg\_%' OR nspname = 'information_schema') THEN 0
ELSE 3 END AS nsptyp,
nsp.nspname, nsp.oid, pg_get_userbyid(nspowner) AS namespaceowner,
nspacl, description, has_schema_privilege(nsp.oid, 'CREATE') as cancreate
FROM pg_namespace nsp
LEFT OUTER JOIN pg_description des ON des.objoid=nsp.oid
ORDER BY 1, nspname
2006-11-09 09:35:12 QUERY : Set query (localhost:5432): SELECT nsp.oid,
substr(nspname, 2) as clustername, nspname, pg_get_userbyid(nspowner) AS
namespaceowner, description
FROM pg_namespace nsp
LEFT OUTER JOIN pg_description des ON des.objoid=nsp.oid
JOIN pg_proc pro ON pronamespace=nsp.oid AND proname = 'slonyversion'
ORDER BY nspname
2006-11-09 09:35:12 QUERY : Scalar query (localhost:5432): SELECT COUNT(*) FROM
(SELECT tgargs from pg_trigger tr
LEFT JOIN pg_depend dep ON dep.objid=tr.oid AND deptype = 'i'
LEFT JOIN pg_constraint co ON refobjid = co.oid AND contype = 'f'
WHERE tgisconstraint AND co.oid IS NULL
GROUP BY tgargs
HAVING count(1) = 3) AS foo
2006-11-09 09:35:12 QUERY : Query result: 0
2006-11-09 09:35:12 QUERY : Set query (localhost:5432): SELECT aggfnoid::oid,
proname AS aggname, pg_get_userbyid(proowner) AS aggowner, aggtransfn,
aggfinalfn, proargtypes[0] AS aggbasetype, CASE WHEN (ti.typlen = -1 AND
ti.typelem != 0) THEN (SELECT at.typname FROM pg_type at WHERE at.oid =
ti.typelem) || '[]' ELSE ti.typname END as inputname, aggtranstype, CASE WHEN
(tt.typlen = -1 AND tt.typelem != 0) THEN (SELECT at.typname FROM pg_type at
WHERE at.oid = tt.typelem) || '[]' ELSE tt.typname END as transname, prorettype
AS aggfinaltype, CASE WHEN (tf.typlen = -1 AND tf.typelem != 0) THEN (SELECT
at.typname FROM pg_type at WHERE at.oid = tf.typelem) || '[]' ELSE tf.typname
END as finalname, agginitval, description
FROM pg_aggregate ag
JOIN pg_proc pr ON pr.oid = ag.aggfnoid
JOIN pg_type ti on ti.oid=proargtypes[0]
JOIN pg_type tt on tt.oid=aggtranstype
JOIN pg_type tf on tf.oid=prorettype
LEFT OUTER JOIN pg_description des ON des.objoid=aggfnoid::oid
WHERE pronamespace = 2200::oid
ORDER BY aggname
2006-11-09 09:35:12 QUERY : Set query (localhost:5432): SELECT co.oid, co.*,
pg_encoding_to_char(conforencoding) as forencoding, pg_get_userbyid(conowner)
as owner,pg_encoding_to_char(contoencoding) as toencoding, proname, nspname,
description
FROM pg_conversion co
JOIN pg_proc pr ON pr.oid=conproc
JOIN pg_namespace na ON na.oid=pr.pronamespace
LEFT OUTER JOIN pg_description des ON des.objoid=co.oid AND des.objsubid=0
WHERE connamespace = 2200::oid
ORDER BY conname
2006-11-09 09:35:12 QUERY : Set query (localhost:5432): SELECT d.oid,
d.typname as domname, d.typbasetype, format_type(b.oid,NULL) as basetype,
pg_get_userbyid(d.typowner) as domainowner,
d.typlen, d.typtypmod, d.typnotnull, d.typdefault, d.typndims,
d.typdelim, bn.nspname as basensp,
description, (SELECT COUNT(1) FROM pg_type t2 WHERE
t2.typname=d.typname) > 1 AS domisdup,
(SELECT COUNT(1) FROM pg_type t3 WHERE t3.typname=b.typname) > 1 AS
baseisdup
FROM pg_type d
JOIN pg_type b ON b.oid = CASE WHEN d.typndims>0 then d.typelem ELSE
d.typbasetype END
JOIN pg_namespace bn ON bn.oid=b.typnamespace
LEFT OUTER JOIN pg_description des ON des.objoid=d.oid
WHERE d.typtype = 'd' AND d.typnamespace = 2200::oid
ORDER BY d.typname
2006-11-09 09:35:12 QUERY : Set query (localhost:5432): SELECT pr.oid,
pr.xmin, pr.*, format_type(TYP.oid, NULL) AS typname, TYPNS.nspname AS typnsp,
lanname, proargnames, pg_get_userbyid(proowner) as funcowner, description
FROM pg_proc pr
JOIN pg_type TYP ON TYP.oid=prorettype
JOIN pg_namespace TYPNS ON TYPNS.oid=TYP.typnamespace
JOIN pg_language LNG ON LNG.oid=prolang
LEFT OUTER JOIN pg_description des ON des.objoid=pr.oid
WHERE proisagg = FALSE AND pronamespace = 2200::oid
AND typname <> 'trigger'
ORDER BY proname
2006-11-09 09:35:12 QUERY : Set query (localhost:5432): SELECT t.oid,
format_type(t.oid, t.typtypmod) AS typname, n.nspname FROM pg_type t,
pg_namespace n WHERE t.typnamespace = n.oid
2006-11-09 09:35:12 QUERY : Set query (localhost:5432): SELECT pr.oid,
pr.xmin, pr.*, format_type(TYP.oid, NULL) AS typname, TYPNS.nspname AS typnsp,
lanname, proargnames, pg_get_userbyid(proowner) as funcowner, description
FROM pg_proc pr
JOIN pg_type TYP ON TYP.oid=prorettype
JOIN pg_namespace TYPNS ON TYPNS.oid=TYP.typnamespace
JOIN pg_language LNG ON LNG.oid=prolang
LEFT OUTER JOIN pg_description des ON des.objoid=pr.oid
WHERE proisagg = FALSE AND pronamespace = 2200::oid
AND typname = 'trigger'
ORDER BY proname
2006-11-09 09:35:12 QUERY : Set query (localhost:5432): SELECT t.oid,
format_type(t.oid, t.typtypmod) AS typname, n.nspname FROM pg_type t,
pg_namespace n WHERE t.typnamespace = n.oid
2006-11-09 09:35:12 QUERY : Set query (localhost:5432): SELECT op.oid,
op.oprname, pg_get_userbyid(op.oprowner) as opowner, op.oprkind, op.oprcanhash,
op.oprleft, op.oprright, lt.typname as lefttype, rt.typname as
righttype, et.typname as resulttype,
co.oprname as compop, ne.oprname as negop, lso.oprname as leftsortop,
rso.oprname as rightsortop,
lco.oprname as lscmpop, gco.oprname as gtcmpop,
op.oprcode as operproc, op.oprjoin as joinproc, op.oprrest as restrproc,
description
FROM pg_operator op
LEFT OUTER JOIN pg_type lt ON lt.oid=op.oprleft
LEFT OUTER JOIN pg_type rt ON rt.oid=op.oprright
JOIN pg_type et on et.oid=op.oprresult
LEFT OUTER JOIN pg_operator co ON co.oid=op.oprcom
LEFT OUTER JOIN pg_operator ne ON ne.oid=op.oprnegate
LEFT OUTER JOIN pg_operator lso ON lso.oid=op.oprlsortop
LEFT OUTER JOIN pg_operator rso ON rso.oid=op.oprrsortop
LEFT OUTER JOIN pg_operator lco ON lco.oid=op.oprltcmpop
LEFT OUTER JOIN pg_operator gco ON gco.oid=op.oprgtcmpop
LEFT OUTER JOIN pg_description
2006-11-09 09:35:12 QUERY : Set query (localhost:5432): SELECT op.oid, op.*,
pg_get_userbyid(op.opcowner) as opowner, it.typname as intypename, dt.typname
as keytypename, amname
FROM pg_opclass op
JOIN pg_am am ON am.oid=opcamid
JOIN pg_type it ON it.oid=opcintype
LEFT OUTER JOIN pg_type dt ON dt.oid=opckeytype
WHERE opcnamespace = 2200::oid
ORDER BY opcname
2006-11-09 09:35:12 QUERY : Set query (localhost:5432): SELECT cl.oid,
relname, pg_get_userbyid(relowner) AS seqowner, relacl, description
FROM pg_class cl
LEFT OUTER JOIN pg_description des ON des.objoid=cl.oid
WHERE relkind = 'S' AND relnamespace = 2200::oid
ORDER BY relname
2006-11-09 09:35:12 QUERY : Set query (localhost:5432): SELECT rel.oid,
relname, spcname, pg_get_userbyid(relowner) AS relowner, relacl, relhasoids,
relhassubclass, reltuples, description, conname, conkey,
EXISTS(select 1 FROM pg_trigger
JOIN pg_proc pt ON pt.oid=tgfoid AND
pt.proname='logtrigger'
JOIN pg_proc pc ON pc.pronamespace=pt.pronamespace AND
pc.proname='slonyversion'
WHERE tgrelid=rel.oid) AS isrepl
FROM pg_class rel
LEFT OUTER JOIN pg_tablespace ta on ta.oid=rel.reltablespace
LEFT OUTER JOIN pg_description des ON (des.objoid=rel.oid AND des.objsubid=0)
LEFT OUTER JOIN pg_constraint c ON c.conrelid=rel.oid AND c.contype='p'
WHERE relkind IN ('r','s','t') AND relnamespace = 2200::oid
ORDER BY relname
2006-11-09 09:35:12 QUERY : Set query (localhost:5432): SELECT t.oid, t.*,
format_type(t.oid, null) AS alias, pg_get_userbyid(t.typowner) as typeowner,
e.typname as element, description, ct.oid AS taboid
FROM pg_type t
LEFT OUTER JOIN pg_type e ON e.oid=t.typelem
LEFT OUTER JOIN pg_class ct ON ct.oid=t.typrelid AND ct.relkind <> 'c'
LEFT OUTER JOIN pg_description des ON des.objoid=t.oid
WHERE t.typtype != 'd' AND t.typname NOT LIKE '\\_%%' AND t.typnamespace =
2200::oid
ORDER BY t.typname
2006-11-09 09:35:12 QUERY : Set query (localhost:5432): SELECT c.oid, c.xmin,
c.relname, pg_get_userbyid(c.relowner) AS viewowner, c.relacl, description,
pg_get_viewdef(c.oid, true) AS definition
FROM pg_class c
LEFT OUTER JOIN pg_description des ON (des.objoid=c.oid and des.objsubid=0)
WHERE ((c.relhasrules AND (EXISTS (
SELECT r.rulename FROM pg_rewrite r
WHERE ((r.ev_class = c.oid)
AND (bpchar(r.ev_type) = '1'::bpchar)) ))) OR (c.relkind =
'v'::char))
AND relnamespace = 2200::oid
ORDER BY relname
2006-11-09 09:35:13 STATUS : Restoring previous environment... (0,50 secs)
2006-11-09 09:35:23 STATUS : Retrieving Table details...
2006-11-09 09:35:23 QUERY : Set query (localhost:5432): SELECT att.*, def.*,
CASE WHEN attndims > 0 THEN 1 ELSE 0 END AS isarray, format_type(ty.oid,NULL)
AS typname, tn.nspname as typnspname, et.typname as elemtypname,
cl.relname, na.nspname, att.attstattarget, description, cs.relname AS
sername, ns.nspname AS serschema,
(SELECT count(1) FROM pg_type t2 WHERE t2.typname=ty.typname) > 1 AS isdup,
indkey,
EXISTS(SELECT 1 FROM pg_constraint WHERE conrelid=att.attrelid AND
contype='f' AND att.attnum=ANY(conkey)) As isfk
FROM pg_attribute att
JOIN pg_type ty ON ty.oid=atttypid
JOIN pg_namespace tn ON tn.oid=ty.typnamespace
JOIN pg_class cl ON cl.oid=attrelid
JOIN pg_namespace na ON na.oid=cl.relnamespace
LEFT OUTER JOIN pg_type et ON et.oid=ty.typelem
LEFT OUTER JOIN pg_attrdef def ON adrelid=attrelid AND adnum=attnum
LEFT OUTER JOIN pg_description des ON des.objoid=attrelid AND
des.objsubid=attnum
LEFT OUTER JOIN (pg_depend JOIN pg_class cs ON objid=cs.oid AND
cs.relkind='S') ON refobjid=attrelid AND refobjsubid=a
2006-11-09 09:35:23 QUERY : Set query (localhost:5432): SELECT DISTINCT
ON(cls.relname) cls.oid, cls.relname as idxname, indrelid, indkey,
indisclustered, indisunique, indisprimary, n.nspname,
indnatts, spcname, tab.relname as tabname, indclass, CASE contype WHEN
'p' THEN desp.description ELSE des.description END AS description,
pg_get_expr(indpred, indrelid, true) as indconstraint, contype,
condeferrable, condeferred, amname
FROM pg_index idx
JOIN pg_class cls ON cls.oid=indexrelid
JOIN pg_class tab ON tab.oid=indrelid
LEFT OUTER JOIN pg_tablespace ta on ta.oid=cls.reltablespace
JOIN pg_namespace n ON n.oid=tab.relnamespace
JOIN pg_am am ON am.oid=cls.relam
LEFT JOIN pg_depend dep ON (dep.classid = cls.tableoid AND dep.objid =
cls.oid AND dep.refobjsubid = '0')
LEFT OUTER JOIN pg_constraint con ON (con.tableoid = dep.refclassid AND
con.oid = dep.refobjid)
LEFT OUTER JOIN pg_description des ON des.objoid=cls.oid
LEFT OUTER JOIN pg_description desp ON (desp.objoid=con.oid AND desp.objsubid
= 0)
WHERE i
2006-11-09 09:35:23 QUERY : Set query (localhost:5432): SELECT ct.oid,
conname, condeferrable, condeferred, confupdtype, confdeltype, confmatchtype,
conkey, confkey, confrelid, nl.nspname as fknsp, cl.relname as fktab,
nr.nspname as refnsp, cr.relname as reftab, description
FROM pg_constraint ct
JOIN pg_class cl ON cl.oid=conrelid
JOIN pg_namespace nl ON nl.oid=cl.relnamespace
JOIN pg_class cr ON cr.oid=confrelid
JOIN pg_namespace nr ON nr.oid=cr.relnamespace
LEFT OUTER JOIN pg_description des ON des.objoid=ct.oid
WHERE contype='f' AND conrelid = 6206193::oid
ORDER BY conname
2006-11-09 09:35:23 QUERY : Set query (localhost:5432): SELECT DISTINCT
ON(cls.relname) cls.oid, cls.relname as idxname, indrelid, indkey,
indisclustered, indisunique, indisprimary, n.nspname,
indnatts, spcname, tab.relname as tabname, indclass, CASE contype WHEN
'p' THEN desp.description ELSE des.description END AS description,
pg_get_expr(indpred, indrelid, true) as indconstraint, contype,
condeferrable, condeferred, amname
FROM pg_index idx
JOIN pg_class cls ON cls.oid=indexrelid
JOIN pg_class tab ON tab.oid=indrelid
LEFT OUTER JOIN pg_tablespace ta on ta.oid=cls.reltablespace
JOIN pg_namespace n ON n.oid=tab.relnamespace
JOIN pg_am am ON am.oid=cls.relam
LEFT JOIN pg_depend dep ON (dep.classid = cls.tableoid AND dep.objid =
cls.oid AND dep.refobjsubid = '0')
LEFT OUTER JOIN pg_constraint con ON (con.tableoid = dep.refclassid AND
con.oid = dep.refobjid)
LEFT OUTER JOIN pg_description des ON des.objoid=cls.oid
LEFT OUTER JOIN pg_description desp ON (desp.objoid=con.oid AND desp.objsubid
= 0)
WHERE i
2006-11-09 09:35:23 QUERY : Set query (localhost:5432): SELECT c.oid, conname,
condeferrable, condeferred, relname, nspname, description,
pg_get_expr(conbin, conrelid, true) as consrc
FROM pg_constraint c
JOIN pg_class cl ON cl.oid=conrelid
JOIN pg_namespace nl ON nl.oid=relnamespace
LEFT OUTER JOIN pg_description des ON des.objoid=c.oid
WHERE contype = 'c' AND conrelid = 6206193::oid
ORDER BY conname
2006-11-09 09:35:23 QUERY : Set query (localhost:5432): SELECT DISTINCT
ON(cls.relname) cls.oid, cls.relname as idxname, indrelid, indkey,
indisclustered, indisunique, indisprimary, n.nspname,
indnatts, spcname, tab.relname as tabname, indclass, CASE contype WHEN
'p' THEN desp.description ELSE des.description END AS description,
pg_get_expr(indpred, indrelid, true) as indconstraint, contype,
condeferrable, condeferred, amname
FROM pg_index idx
JOIN pg_class cls ON cls.oid=indexrelid
JOIN pg_class tab ON tab.oid=indrelid
LEFT OUTER JOIN pg_tablespace ta on ta.oid=cls.reltablespace
JOIN pg_namespace n ON n.oid=tab.relnamespace
JOIN pg_am am ON am.oid=cls.relam
LEFT JOIN pg_depend dep ON (dep.classid = cls.tableoid AND dep.objid =
cls.oid AND dep.refobjsubid = '0')
LEFT OUTER JOIN pg_constraint con ON (con.tableoid = dep.refclassid AND
con.oid = dep.refobjid)
LEFT OUTER JOIN pg_description des ON des.objoid=cls.oid
LEFT OUTER JOIN pg_description desp ON (desp.objoid=con.oid AND desp.objsubid
= 0)
WHERE i
2006-11-09 09:35:23 QUERY : Set query (localhost:5432): SELECT rw.oid,
rw.ev_class, rulename, relname, nspname, description, is_instead, ev_type,
ev_action, ev_qual,
pg_get_ruledef(rw.oid, true) AS definition
FROM pg_rewrite rw
JOIN pg_class cl ON cl.oid=rw.ev_class
JOIN pg_namespace nsp ON nsp.oid=cl.relnamespace
LEFT OUTER JOIN pg_description des ON des.objoid=rw.oid
WHERE ev_class = 6206193
ORDER BY rulename
2006-11-09 09:35:23 QUERY : Set query (localhost:5432): SELECT t.oid, t.*,
relname, nspname, des.description
FROM pg_trigger t
JOIN pg_class cl ON cl.oid=tgrelid
JOIN pg_namespace na ON na.oid=relnamespace
LEFT OUTER JOIN pg_description des ON des.objoid=t.oid
WHERE NOT tgisconstraint
AND tgrelid = 6206193::oid
ORDER BY tgname
2006-11-09 09:35:23 QUERY : Set query (localhost:5432): SELECT attname
FROM pg_attribute
WHERE attrelid=6206193::oid AND attnum IN (2)
2006-11-09 09:35:23 QUERY : Set query (localhost:5432): SELECT attname
FROM pg_attribute
WHERE attrelid=6206193::oid AND attnum IN (7)
2006-11-09 09:35:23 QUERY : Set query (localhost:5432): SELECT count(*) AS
rows FROM ONLY hd_tecnicos
2006-11-09 09:35:23 QUERY : Set query (localhost:5432): SELECT c.relname ,
nspname
FROM pg_inherits i
JOIN pg_class c ON c.oid = i.inhparent
JOIN pg_namespace n ON n.oid=c.relnamespace
WHERE i.inhrelid = 6206193::oid
ORDER BY inhseqno
2006-11-09 09:35:23 STATUS : Retrieving Table details... (0,26 secs)
2006-11-09 09:35:23 QUERY : Scalar query (localhost:5432): SELECT
CASE WHEN (o.opcdefault = FALSE AND o.opcintype != a.atttypid) THEN
pg_get_indexdef(i.indexrelid, 1, true) || ' ' || o.opcname
ELSE
pg_get_indexdef(i.indexrelid, 1, true)
END
FROM pg_index i
JOIN pg_attribute a ON (a.attrelid = i.indexrelid AND attnum = 1)
LEFT OUTER JOIN pg_opclass o ON (o.oid = i.indclass[0])
WHERE i.indexrelid = 6209046::oid
2006-11-09 09:35:23 QUERY : Query result: idempresa
2006-11-09 09:35:23 QUERY : Scalar query (localhost:5432): SELECT
CASE WHEN (o.opcdefault = FALSE AND o.opcintype != a.atttypid) THEN
pg_get_indexdef(i.indexrelid, 2, true) || ' ' || o.opcname
ELSE
pg_get_indexdef(i.indexrelid, 2, true)
END
FROM pg_index i
JOIN pg_attribute a ON (a.attrelid = i.indexrelid AND attnum = 2)
LEFT OUTER JOIN pg_opclass o ON (o.oid = i.indclass[1])
WHERE i.indexrelid = 6209046::oid
2006-11-09 09:35:23 QUERY : Query result: idusuario
2006-11-09 09:35:23 QUERY : Set query (localhost:5432): SELECT opcname FROM
pg_opclass WHERE oid=1978
2006-11-09 09:35:23 QUERY : Set query (localhost:5432): SELECT opcname FROM
pg_opclass WHERE oid=1978
2006-11-09 09:35:23 QUERY : Scalar query (localhost:5432): SELECT
CASE WHEN (o.opcdefault = FALSE AND o.opcintype != a.atttypid) THEN
pg_get_indexdef(i.indexrelid, 1, true) || ' ' || o.opcname
ELSE
pg_get_indexdef(i.indexrelid, 1, true)
END
FROM pg_index i
JOIN pg_attribute a ON (a.attrelid = i.indexrelid AND attnum = 1)
LEFT OUTER JOIN pg_opclass o ON (o.oid = i.indclass[0])
WHERE i.indexrelid = 6209046::oid
2006-11-09 09:35:23 QUERY : Query result: idempresa
2006-11-09 09:35:23 QUERY : Scalar query (localhost:5432): SELECT
CASE WHEN (o.opcdefault = FALSE AND o.opcintype != a.atttypid) THEN
pg_get_indexdef(i.indexrelid, 2, true) || ' ' || o.opcname
ELSE
pg_get_indexdef(i.indexrelid, 2, true)
END
FROM pg_index i
JOIN pg_attribute a ON (a.attrelid = i.indexrelid AND attnum = 2)
LEFT OUTER JOIN pg_opclass o ON (o.oid = i.indclass[1])
WHERE i.indexrelid = 6209046::oid
2006-11-09 09:35:23 QUERY : Query result: idusuario
2006-11-09 09:35:23 QUERY : Set query (localhost:5432): SELECT opcname FROM
pg_opclass WHERE oid=1978
2006-11-09 09:35:23 QUERY : Set query (localhost:5432): SELECT opcname FROM
pg_opclass WHERE oid=1978
2006-11-09 09:35:23 QUERY : Set query (localhost:5432): SELECT rw.oid,
rw.ev_class, rulename, relname, nspname, description, is_instead, ev_type,
ev_action, ev_qual,
pg_get_ruledef(rw.oid, true) AS definition
FROM pg_rewrite rw
JOIN pg_class cl ON cl.oid=rw.ev_class
JOIN pg_namespace nsp ON nsp.oid=cl.relnamespace
LEFT OUTER JOIN pg_description des ON des.objoid=rw.oid
WHERE ev_class = 6206193
ORDER BY rulename
2006-11-09 09:35:23 QUERY : Set query (localhost:5432): SELECT t.oid, t.*,
relname, nspname, des.description
FROM pg_trigger t
JOIN pg_class cl ON cl.oid=tgrelid
JOIN pg_namespace na ON na.oid=relnamespace
LEFT OUTER JOIN pg_description des ON des.objoid=t.oid
WHERE NOT tgisconstraint
AND tgrelid = 6206193::oid
ORDER BY tgname
2006-11-09 09:35:40 QUERY : Set query (localhost:5432): SET
DateStyle=ISO;SELECT oid, pg_encoding_to_char(encoding) AS encoding,
datlastsysoid
FROM pg_database WHERE oid = 6205160
2006-11-09 09:35:40 QUERY : Thread Query SELECT * FROM hd_tecnicos ORDER BY
idempresa, idusuario ASC
2006-11-09 09:35:40 QUERY : Set query (localhost:5432): SELECT n.nspname AS
nspname, relname, format_type(t.oid,NULL) AS typname, format_type(t.oid,
att.atttypmod) AS displaytypname, nt.nspname AS typnspname, attname, attnum,
COALESCE(b.oid, t.oid) AS basetype, atthasdef, adsrc,
CASE WHEN t.typbasetype::oid=0 THEN att.atttypmod else t.typtypmod END
AS typmod,
CASE WHEN t.typbasetype::oid=0 THEN att.attlen else t.typlen END AS
typlen
FROM pg_attribute att
JOIN pg_type t ON t.oid=att.atttypid
JOIN pg_namespace nt ON nt.oid=t.typnamespace
JOIN pg_class c ON c.oid=attrelid
JOIN pg_namespace n ON n.oid=relnamespace
LEFT OUTER JOIN pg_type b ON b.oid=t.typbasetype
LEFT OUTER JOIN pg_attrdef def ON adrelid=attrelid AND adnum=attnum
WHERE attnum > 0 AND NOT attisdropped AND attrelid=6206193::oid
ORDER BY attnum
2006-11-09 09:35:40 QUERY : Scalar query (localhost:5432): SELECT
format_type(oid,NULL) as typname FROM pg_type WHERE oid = 23
2006-11-09 09:35:40 QUERY : Query result: integer
2006-11-09 09:35:40 QUERY : Scalar query (localhost:5432): SELECT
format_type(oid,NULL) as typname FROM pg_type WHERE oid = 23
2006-11-09 09:35:40 QUERY : Query result: integer
2006-11-09 09:35:40 QUERY : Scalar query (localhost:5432): SELECT
format_type(oid,NULL) as typname FROM pg_type WHERE oid = 21
2006-11-09 09:35:41 QUERY : Query result: smallint
2006-11-09 09:35:41 QUERY : Scalar query (localhost:5432): SELECT
format_type(oid,NULL) as typname FROM pg_type WHERE oid = 23
2006-11-09 09:35:41 QUERY : Query result: integer
2006-11-09 09:35:41 QUERY : Scalar query (localhost:5432): SELECT
format_type(oid,NULL) as typname FROM pg_type WHERE oid = 23
2006-11-09 09:35:41 QUERY : Query result: integer
2006-11-09 09:35:51 QUERY : Set query (localhost:5432): INSERT INTO
hd_tecnicos(idempresa, ativo, idusuario, idpessoa) VALUES (6::integer,
1::smallint, 11::integer, 1::integer)
2006-11-09 09:35:51 QUERY : Scalar query (localhost:5432): SELECT version();
2006-11-09 09:35:51 QUERY : Query result: PostgreSQL 8.0.8 on i686-pc-mingw32,
compiled by GCC gcc.exe (GCC) 3.4.2 (mingw-special)
2006-11-09 09:39:52 STATUS : Retrieving Servers details...
2006-11-09 09:39:52 STATUS : Retrieving Servers details... (0,00 secs)
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
