Обсуждение: pgadmin III: query builder

Поиск

Список

Период

Сортировка

pgadmin III: query builder

От

Marc Cuypers

Дата:

16 июня 2003 г., 09:14:27

Hi,

I'm using pgadmin III (windows XP) with pgsql 7.3.3 (linux debian 3) as
backend.

When I try to add a table (query builder/tools/add a table) I get the
following error message:
    ' ERROR: parser: parser error at or neqr "a" at character 201'

Am I doing something wrong?

--
Best regards,

M.

Re: pgadmin III: query builder

От

"Dave Page"

Дата:

16 июня 2003 г., 09:17:36


> -----Original Message-----
> From: Marc Cuypers [mailto:mozilla@mgvd.be]
> Sent: 16 June 2003 10:14
> To: pgadmin-hackers@postgresql.org
> Subject: [pgadmin-hackers] pgadmin III: query builder
>
>
> Hi,
>
> I'm using pgadmin III (windows XP) with pgsql 7.3.3 (linux
> debian 3) as
> backend.
>
> When I try to add a table (query builder/tools/add a table) I get the
> following error message:
>     ' ERROR: parser: parser error at or neqr "a" at character 201'
>
> Am I doing something wrong?

Probably not - it's alpha software :-)

Can you switch on logging to Errors & SQL under File -> Options ->
Logging, recreate the error and send us the logfile please?

Cheers, Dave.

Re: pgadmin III: query builder

От

Marc Cuypers

Дата:

16 июня 2003 г., 09:23:41

Dave Page wrote:

>
>>-----Original Message-----
>>From: Marc Cuypers [mailto:mozilla@mgvd.be]
>>Sent: 16 June 2003 10:14
>>To: pgadmin-hackers@postgresql.org
>>Subject: [pgadmin-hackers] pgadmin III: query builder
>>
>>
>>Hi,
>>
>>I'm using pgadmin III (windows XP) with pgsql 7.3.3 (linux
>>debian 3) as
>>backend.
>>
>>When I try to add a table (query builder/tools/add a table) I get the
>>following error message:
>>    ' ERROR: parser: parser error at or neqr "a" at character 201'
>>
>>Am I doing something wrong?
>
>
> Probably not - it's alpha software :-)
>
> Can you switch on logging to Errors & SQL under File -> Options ->
> Logging, recreate the error and send us the logfile please?
>
> Cheers, Dave.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend
>
>
last lines in the logfile:
2003-06-16 11:16:03 ERROR  : ERROR:  parser: parse error at or near "a"
at character 201

2003-06-16 11:16:05 ERROR  : ERROR:  parser: parse error at or near "a"
at character 201

2003-06-16 11:19:48 QUERY  : Set query (test:5432): SELECT a.relname
FROM pg_class a JOIN (SELECT oid,nspname FROM pg_namespace WHERE nspname
<> 'pg_catalog' AND nspname <> 'pg_toast' AND nspname NOT LIKE
'pg_temp_%' ) b ON a.relnamespace = b.oidWHERE a.relkind='r' ORDER BY
lower(a.relname)
2003-06-16 11:19:48 ERROR  : ERROR:  parser: parse error at or near "a"
at character 201

2003-06-16 11:19:51 QUERY  : Set query (test:5432): SELECT a.relname
FROM pg_class a JOIN (SELECT oid,nspname FROM pg_namespace WHERE nspname
<> 'pg_catalog' AND nspname <> 'pg_toast' AND nspname NOT LIKE
'pg_temp_%' ) b ON a.relnamespace = b.oidWHERE a.relkind='v' ORDER BY
lower(a.relname)
2003-06-16 11:19:51 ERROR  : ERROR:  parser: parse error at or near "a"
at character 201



--
Best regards,

M.

Re: pgadmin III: query builder

От

"Dave Page"

Дата:

16 июня 2003 г., 09:54:30

Hi Marc,

I believe I have fixed this - can I email you an updated .exe?

Regards, Dave.

> -----Original Message-----
> From: Marc Cuypers [mailto:mozilla@mgvd.be]
> Sent: 16 June 2003 10:23
> To: Dave Page
> Cc: pgadmin-hackers@postgresql.org
> Subject: Re: [pgadmin-hackers] pgadmin III: query builder
>
>
> Dave Page wrote:
>
> >
> >>-----Original Message-----
> >>From: Marc Cuypers [mailto:mozilla@mgvd.be]
> >>Sent: 16 June 2003 10:14
> >>To: pgadmin-hackers@postgresql.org
> >>Subject: [pgadmin-hackers] pgadmin III: query builder
> >>
> >>
> >>Hi,
> >>
> >>I'm using pgadmin III (windows XP) with pgsql 7.3.3 (linux
> >>debian 3) as
> >>backend.
> >>
> >>When I try to add a table (query builder/tools/add a table)
> I get the
> >>following error message:
> >>    ' ERROR: parser: parser error at or neqr "a" at character 201'
> >>
> >>Am I doing something wrong?
> >
> >
> > Probably not - it's alpha software :-)
> >
> > Can you switch on logging to Errors & SQL under File -> Options ->
> > Logging, recreate the error and send us the logfile please?
> >
> > Cheers, Dave.
> >
> > ---------------------------(end of
> > broadcast)---------------------------
> > TIP 8: explain analyze is your friend
> >
> >
> last lines in the logfile:
> 2003-06-16 11:16:03 ERROR  : ERROR:  parser: parse error at
> or near "a"
> at character 201
>
> 2003-06-16 11:16:05 ERROR  : ERROR:  parser: parse error at
> or near "a"
> at character 201
>
> 2003-06-16 11:19:48 QUERY  : Set query (test:5432): SELECT a.relname
> FROM pg_class a JOIN (SELECT oid,nspname FROM pg_namespace
> WHERE nspname
> <> 'pg_catalog' AND nspname <> 'pg_toast' AND nspname NOT LIKE
> 'pg_temp_%' ) b ON a.relnamespace = b.oidWHERE a.relkind='r' ORDER BY
> lower(a.relname)
> 2003-06-16 11:19:48 ERROR  : ERROR:  parser: parse error at
> or near "a"
> at character 201
>
> 2003-06-16 11:19:51 QUERY  : Set query (test:5432): SELECT a.relname
> FROM pg_class a JOIN (SELECT oid,nspname FROM pg_namespace
> WHERE nspname
> <> 'pg_catalog' AND nspname <> 'pg_toast' AND nspname NOT LIKE
> 'pg_temp_%' ) b ON a.relnamespace = b.oidWHERE a.relkind='v' ORDER BY
> lower(a.relname)
> 2003-06-16 11:19:51 ERROR  : ERROR:  parser: parse error at
> or near "a"
> at character 201
>
>
>
> --
> Best regards,
>
> M.
>
>

Re: pgadmin III: query builder

От

"Dave Page"

Дата:

16 июня 2003 г., 14:34:01


> -----Original Message-----
> From: Marc Cuypers [mailto:mozilla@mgvd.be]
> Sent: 16 June 2003 12:27
> To: Dave Page
> Subject: Re: [pgadmin-hackers] pgadmin III: query builder
>
>
> I installed te xrc files.
>
> Now the logging window works.  I activated debug mode.
> The problem in query builder is still there.  The program
> crashes when I
> selected a table (in add table) and clicked OK.
>
> Hereunder the output in the logfile:

I can repeat it sometimes, but not others - couldn't see a pattern,
though double-clicks seem to be more vulnerable on my system.

Keith, any ideas what's going on? You know the code far better than I...

Regards, Dave.



-------------START
2003-06-16 13:21:13 STATUS : Retrieving server properties...
2003-06-16 13:21:13 STATUS : Retrieving server properties... Done. (0.12

secs)
2003-06-16 13:21:15 STATUS : Connecting to database without password...
2003-06-16 13:21:15 STATUS : Connecting to database without password...
Done. (0.19 secs)
2003-06-16 13:21:15 QUERY  : Scalar query (test:5432): SELECT version();
2003-06-16 13:21:15 QUERY  : Query result: PostgreSQL 7.3.3 on
i686-pc-linux-gnu, compiled by GCC 2.95.4
2003-06-16 13:21:15 QUERY  : Set query (test:5432): SELECT db.oid,
datname, datpath, datallowconn, datconfig, datacl,
pg_encoding_to_char(encoding) AS serverencoding, pg_get_userbyid(datdba)

AS datowner
   FROM pg_database db
  ORDER BY datname
2003-06-16 13:21:15 QUERY  : Scalar query (test:5432): SELECT
datlastsysoid FROM pg_database LIMIT 1;
2003-06-16 13:21:15 QUERY  : Query result: 16974
2003-06-16 13:21:15 QUERY  : Set query (test:5432): SELECT * from
pg_group
2003-06-16 13:21:15 QUERY  : Set query (test:5432): SELECT * FROM
pg_shadow
2003-06-16 13:21:15 STATUS : Retrieving Databases details...
2003-06-16 13:21:15 STATUS : Retrieving Databases details... Done. (0.00

secs)
2003-06-16 13:21:15 STATUS : Retrieving Database details...
2003-06-16 13:21:16 QUERY  : Set query (test:5432): SELECT DEFS.*,
description
   FROM (SELECT
   (SELECT proname FROM pg_proc WHERE proname IN ('pg_get_viewdef',
'pg_get_viewdef2') AND pronamespace=11 ORDER BY proname DESC LIMIT 1) AS

get_viewdef,
   (SELECT proname FROM pg_proc WHERE proname IN ('pg_get_ruledef',
'pg_get_ruledef2') AND pronamespace=11 ORDER BY proname DESC LIMIT 1) AS

get_ruledef,
   (SELECT proname FROM pg_proc WHERE proname IN ('pg_get_expr',
'pg_get_expr2') AND pronamespace=11 ORDER BY proname DESC LIMIT 1) AS
get_expr,
  'nix' as get_ruledef, 'expr' as get_expr
        ) AS DEFS
   LEFT OUTER JOIN pg_description ON objoid=132878::oid
2003-06-16 13:21:16 QUERY  : Set query (test:5432): SELECT ca.oid, ca.*,

st.typname AS srctyp, tt.typname AS trgtyp, proname, nspname
   FROM pg_cast ca
   JOIN pg_type st ON st.oid=castsource
   JOIN pg_type tt ON tt.oid=casttarget
   JOIN pg_proc pr ON pr.oid=castfunc
   JOIN pg_namespace na ON na.oid=pr.pronamespace
  ORDER BY st.typname, tt.typname
2003-06-16 13:21:16 QUERY  : Set query (test:5432): SELECT lan.oid,
lan.lanname, lanpltrusted, lanacl, hp.proname as lanproc, vp.proname as
lanval
   FROM pg_language lan
   JOIN pg_proc hp on hp.oid=lanplcallfoid
   LEFT OUTER JOIN pg_proc vp on vp.oid=lanvalidator
  WHERE lanispl IS TRUE
  ORDER BY lanname
2003-06-16 13:21:16 QUERY  : Set query (test:5432): SELECT CASE WHEN
nsp.oid<100 THEN 0 WHEN nspname LIKE 'pg\_temp\_%%' THEN 1 ELSE 2 END AS

nsptyp,
        nsp.nspname, nsp.oid, pg_get_userbyid(nspowner) AS
namespaceowner, nspacl, description
   FROM pg_namespace nsp
   LEFT OUTER JOIN pg_description des ON des.objoid=nsp.oid
  WHERE nsp.oid >= 100
    AND nsp.nspname NOT LIKE 'pg\_temp\_%'
  ORDER BY 1, nspname
2003-06-16 13:21:16 STATUS : Retrieving Database details... Done. (0.28
secs)
2003-06-16 13:21:16 STATUS : Retrieving Schemas details...
2003-06-16 13:21:16 STATUS : Retrieving Schemas details... Done. (0.00
secs)
2003-06-16 13:21:16 STATUS : Retrieving Schema details...
2003-06-16 13:21:16 QUERY  : Set query (test: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 = 132946::oid
  ORDER BY aggname
2003-06-16 13:21:16 QUERY  : Set query (test: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
   FROM pg_conversion co
   JOIN pg_proc pr ON pr.oid=conproc
   JOIN pg_namespace na ON na.oid=pr.pronamespace
  WHERE connamespace = 132946::oid
  ORDER BY conname
2003-06-16 13:21:16 QUERY  : Set query (test:5432): SELECT d.oid,
d.typname as domname, d.typbasetype, b.typname as basetype,
pg_get_userbyid(d.typowner) as domainowner,
        d.typlen, d.typtypmod, d.typnotnull, d.typdefault, d.typndims,
d.typdelim,
        description
   FROM pg_type d
   JOIN pg_type b ON b.oid = CASE WHEN d.typndims>0 then d.typelem ELSE
d.typbasetype END
   LEFT OUTER JOIN pg_description des ON des.objoid=d.oid
  WHERE d.typtype = 'd' AND d.typnamespace = 132946::oid
  ORDER BY d.typname
2003-06-16 13:21:16 QUERY  : Set query (test:5432): SELECT pr.oid, pr.*,

TYP.typname, lanname, pg_get_userbyid(proowner) as funcowner,
description
   FROM pg_proc pr
   JOIN pg_type TYP ON TYP.oid=prorettype
   JOIN pg_language LNG ON LNG.oid=prolang
   LEFT OUTER JOIN pg_description des ON des.objoid=pr.oid
  WHERE proisagg = FALSE AND pronamespace = 132946::oid
    AND typname <> 'trigger'
  ORDER BY proname
2003-06-16 13:21:16 QUERY  : Set query (test:5432): SELECT oid, typname
FROM pg_type
2003-06-16 13:21:16 QUERY  : Set query (test:5432): SELECT pr.oid, pr.*,

TYP.typname, lanname, pg_get_userbyid(proowner) as funcowner,
description
   FROM pg_proc pr
   JOIN pg_type TYP ON TYP.oid=prorettype
   JOIN pg_language LNG ON LNG.oid=prolang
   LEFT OUTER JOIN pg_description des ON des.objoid=pr.oid
  WHERE proisagg = FALSE AND pronamespace = 132946::oid
    AND typname = 'trigger'
  ORDER BY proname
2003-06-16 13:21:16 QUERY  : Set query (test:5432): SELECT oid, typname
FROM pg_type
2003-06-16 13:21:16 QUERY  : Set query (test: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,
        po.proname as operproc, pj.proname as joinproc, pr.proname as
restrproc, description
   FROM pg_operator op
   JOIN pg_type lt ON lt.oid=op.oprleft
   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
   JOIN pg_proc po ON po.oid=op.oprcode
   LEFT OUTER JOIN pg_
2003-06-16 13:21:16 QUERY  : Set query (test:5432): SELECT op.oid, op.*,

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 = 132946::oid
  ORDER BY opcname
2003-06-16 13:21:16 QUERY  : Set query (test: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  = 132946::oid
  ORDER BY relname
2003-06-16 13:21:16 QUERY  : Set query (test:5432): SELECT rel.oid,
relname, pg_get_userbyid(relowner) AS relowner, relacl, relhasoids,
relhassubclass, reltuples, description, conname, conkey
   FROM pg_class rel
   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 = 'r') OR (relkind = 's')) AND relnamespace =
132946::oid
  ORDER BY relname
2003-06-16 13:21:16 QUERY  : Set query (test:5432): SELECT t.oid, t.*,
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 = 132946::oid
    AND ct.oid IS NULL
  ORDER BY t.typname
2003-06-16 13:21:16 QUERY  : Set query (test:5432): SELECT c.oid,
c.relname, pg_get_userbyid(c.relowner) AS viewowner, c.relacl,
description, pg_get_viewdef(c.oid) AS definition
   FROM pg_class c
   LEFT OUTER JOIN pg_description des ON des.objoid=c.oid
  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 = 132946::oid
  ORDER BY relname
2003-06-16 13:21:16 STATUS : Retrieving Schema details... Done. (0.32
secs)
2003-06-16 13:21:16 STATUS : Retrieving Schema details...
2003-06-16 13:21:16 STATUS : Retrieving Schema details... Done. (0.00
secs)
2003-06-16 13:21:25 QUERY  : Set query (test:5432): SELECT a.relname
FROM pg_class a JOIN (SELECT oid,nspname FROM pg_namespace WHERE nspname

<> 'pg_catalog' AND nspname <> 'pg_toast' AND nspname NOT LIKE
'pg_temp_%' ) b ON a.relnamespace = b.oid WHERE a.relkind='r' ORDER BY
lower(a.relname)
2003-06-16 13:21:25 QUERY  : Set query (test:5432): SELECT a.relname
FROM pg_class a JOIN (SELECT oid,nspname FROM pg_namespace WHERE nspname

<> 'pg_catalog' AND nspname <> 'pg_toast' AND nspname NOT LIKE
'pg_temp_%' ) b ON a.relnamespace = b.oid WHERE a.relkind='v' ORDER BY
lower(a.relname)
2003-06-16 13:21:46 INFO   : Destroying an options dialogue
2003-06-16 13:21:49 STATUS : Retrieving server properties...
2003-06-16 13:21:49 INFO   : Displaying properties for Server test:5432
2003-06-16 13:21:49 INFO   : Displaying properties for server test:5432
2003-06-16 13:21:49 STATUS : Retrieving server properties... Done. (0.00

secs)
2003-06-16 13:21:50 INFO   : Attempting to create a connection object...
2003-06-16 13:21:50 INFO   : Creating a connect dialogue
2003-06-16 13:21:52 INFO   : Destroying a connect dialogue
2003-06-16 13:21:52 STATUS : Connecting to database without password...
2003-06-16 13:21:52 INFO   : Creating pgConn object
2003-06-16 13:21:52 INFO   : Server name: test (resolved to: 10.0.0.224)
2003-06-16 13:21:52 INFO   : Opening connection with connection string:
hostaddr=10.0.0.224 dbname=template1 user=postgres port=5432
2003-06-16 13:21:52 INFO   : Setting client_encoding to 'UNICODE'
2003-06-16 13:21:52 STATUS : Connecting to database without password...
Done. (0.03 secs)
2003-06-16 13:21:52 QUERY  : Scalar query (test:5432): SELECT version();
2003-06-16 13:21:52 QUERY  : Query result: PostgreSQL 7.3.3 on
i686-pc-linux-gnu, compiled by GCC 2.95.4
2003-06-16 13:21:52 INFO   : pgServer object initialised as required.
2003-06-16 13:21:52 INFO   : Adding child object to server test:5432
2003-06-16 13:21:52 INFO   : Creating a pgCollection object
2003-06-16 13:21:52 QUERY  : Set query (test:5432): SELECT db.oid,
datname, datpath, datallowconn, datconfig, datacl,
pg_encoding_to_char(encoding) AS serverencoding, pg_get_userbyid(datdba)

AS datowner
   FROM pg_database db
  ORDER BY datname
2003-06-16 13:21:52 INFO   : Creating pgSet object
2003-06-16 13:21:52 INFO   : Creating a pgDatabase object
2003-06-16 13:21:52 QUERY  : Scalar query (test:5432): SELECT
datlastsysoid FROM pg_database LIMIT 1;
2003-06-16 13:21:52 QUERY  : Query result: 16974
2003-06-16 13:21:52 INFO   : Creating a pgDatabase object
2003-06-16 13:21:52 INFO   : Creating a pgDatabase object
2003-06-16 13:21:52 INFO   : Creating a pgDatabase object
2003-06-16 13:21:52 INFO   : Creating a pgDatabase object
2003-06-16 13:21:52 INFO   : Creating a pgDatabase object
2003-06-16 13:21:52 INFO   : Creating a pgDatabase object
2003-06-16 13:21:52 INFO   : Creating a pgDatabase object
2003-06-16 13:21:52 INFO   : Destroying a pgDatabase object
2003-06-16 13:21:52 INFO   : Creating a pgDatabase object
2003-06-16 13:21:52 INFO   : Destroying a pgDatabase object
2003-06-16 13:21:52 INFO   : Creating a pgDatabase object
2003-06-16 13:21:52 INFO   : Creating a pgDatabase object
2003-06-16 13:21:52 INFO   : Destroying pgSet object
2003-06-16 13:21:52 INFO   : Creating a pgCollection object
2003-06-16 13:21:52 QUERY  : Set query (test:5432): SELECT * from
pg_group
2003-06-16 13:21:52 INFO   : Creating pgSet object
2003-06-16 13:21:52 INFO   : Creating a pgGroup object
2003-06-16 13:21:52 INFO   : Destroying pgSet object
2003-06-16 13:21:52 INFO   : Creating a pgCollection object
2003-06-16 13:21:52 QUERY  : Set query (test:5432): SELECT * FROM
pg_shadow
2003-06-16 13:21:52 INFO   : Creating pgSet object
2003-06-16 13:21:52 INFO   : Creating a pgUser object
2003-06-16 13:21:52 INFO   : Creating a pgUser object
2003-06-16 13:21:52 INFO   : Creating a pgUser object
2003-06-16 13:21:52 INFO   : Destroying pgSet object
2003-06-16 13:21:52 INFO   : Displaying properties for Databases
Databases
2003-06-16 13:21:52 STATUS : Retrieving Databases details...
2003-06-16 13:21:52 STATUS : Retrieving Databases details... Done. (0.00

secs)
2003-06-16 13:21:52 INFO   : Displaying properties for Database mgvd
2003-06-16 13:21:52 STATUS : Retrieving Database details...
2003-06-16 13:21:52 INFO   : Creating pgConn object
2003-06-16 13:21:52 INFO   : Server name: test (resolved to: 10.0.0.224)
2003-06-16 13:21:52 INFO   : Opening connection with connection string:
hostaddr=10.0.0.224 dbname=mgvd user=postgres port=5432
2003-06-16 13:21:52 INFO   : Setting client_encoding to 'UNICODE'
2003-06-16 13:21:52 QUERY  : Set query (test:5432): SELECT DEFS.*,
description
   FROM (SELECT
   (SELECT proname FROM pg_proc WHERE proname IN ('pg_get_viewdef',
'pg_get_viewdef2') AND pronamespace=11 ORDER BY proname DESC LIMIT 1) AS

get_viewdef,
   (SELECT proname FROM pg_proc WHERE proname IN ('pg_get_ruledef',
'pg_get_ruledef2') AND pronamespace=11 ORDER BY proname DESC LIMIT 1) AS

get_ruledef,
   (SELECT proname FROM pg_proc WHERE proname IN ('pg_get_expr',
'pg_get_expr2') AND pronamespace=11 ORDER BY proname DESC LIMIT 1) AS
get_expr,
  'nix' as get_ruledef, 'expr' as get_expr
        ) AS DEFS
   LEFT OUTER JOIN pg_description ON objoid=132878::oid
2003-06-16 13:21:52 INFO   : Creating pgSet object
2003-06-16 13:21:52 INFO   : Destroying pgSet object
2003-06-16 13:21:52 INFO   : Adding child object to database mgvd
2003-06-16 13:21:52 INFO   : Creating a pgCollection object
2003-06-16 13:21:52 QUERY  : Set query (test:5432): SELECT ca.oid, ca.*,

st.typname AS srctyp, tt.typname AS trgtyp, proname, nspname
   FROM pg_cast ca
   JOIN pg_type st ON st.oid=castsource
   JOIN pg_type tt ON tt.oid=casttarget
   JOIN pg_proc pr ON pr.oid=castfunc
   JOIN pg_namespace na ON na.oid=pr.pronamespace
  ORDER BY st.typname, tt.typname
2003-06-16 13:21:52 INFO   : Creating pgSet object
2003-06-16 13:21:52 INFO   : Destroying pgSet object
2003-06-16 13:21:52 INFO   : Creating a pgCollection object
2003-06-16 13:21:52 QUERY  : Set query (test:5432): SELECT lan.oid,
lan.lanname, lanpltrusted, lanacl, hp.proname as lanproc, vp.proname as
lanval
   FROM pg_language lan
   JOIN pg_proc hp on hp.oid=lanplcallfoid
   LEFT OUTER JOIN pg_proc vp on vp.oid=lanvalidator
  WHERE lanispl IS TRUE
  ORDER BY lanname
2003-06-16 13:21:52 INFO   : Creating pgSet object
2003-06-16 13:21:52 INFO   : Destroying pgSet object
2003-06-16 13:21:52 INFO   : Creating a pgCollection object
2003-06-16 13:21:52 QUERY  : Set query (test:5432): SELECT CASE WHEN
nsp.oid<100 THEN 0 WHEN nspname LIKE 'pg\_temp\_%%' THEN 1 ELSE 2 END AS

nsptyp,
        nsp.nspname, nsp.oid, pg_get_userbyid(nspowner) AS
namespaceowner, nspacl, description
   FROM pg_namespace nsp
   LEFT OUTER JOIN pg_description des ON des.objoid=nsp.oid
  WHERE nsp.oid >= 100
    AND nsp.nspname NOT LIKE 'pg\_temp\_%'
  ORDER BY 1, nspname
2003-06-16 13:21:52 INFO   : Creating pgSet object
2003-06-16 13:21:52 INFO   : Creating a pgSchema object
2003-06-16 13:21:52 INFO   : Creating a pgSchema object
2003-06-16 13:21:52 INFO   : Creating a pgSchema object
2003-06-16 13:21:52 INFO   : Creating a pgSchema object
2003-06-16 13:21:52 INFO   : Creating a pgSchema object
2003-06-16 13:21:52 INFO   : Creating a pgSchema object
2003-06-16 13:21:52 INFO   : Creating a pgSchema object
2003-06-16 13:21:52 INFO   : Destroying pgSet object
2003-06-16 13:21:52 STATUS : Retrieving Database details... Done. (0.24
secs)
2003-06-16 13:21:52 INFO   : Displaying properties for Schemas Schemas
2003-06-16 13:21:52 STATUS : Retrieving Schemas details...
2003-06-16 13:21:52 STATUS : Retrieving Schemas details... Done. (0.00
secs)
2003-06-16 13:21:52 INFO   : Displaying properties for Schema security
2003-06-16 13:21:52 STATUS : Retrieving Schema details...
2003-06-16 13:21:52 INFO   : Adding child object to schema security
2003-06-16 13:21:52 INFO   : Creating a pgCollection object
2003-06-16 13:21:52 QUERY  : Set query (test: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 = 132946::oid
  ORDER BY aggname
2003-06-16 13:21:52 INFO   : Creating pgSet object
2003-06-16 13:21:52 INFO   : Destroying pgSet object
2003-06-16 13:21:52 INFO   : Creating a pgCollection object
2003-06-16 13:21:52 QUERY  : Set query (test: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
   FROM pg_conversion co
   JOIN pg_proc pr ON pr.oid=conproc
   JOIN pg_namespace na ON na.oid=pr.pronamespace
  WHERE connamespace = 132946::oid
  ORDER BY conname
2003-06-16 13:21:52 INFO   : Creating pgSet object
2003-06-16 13:21:52 INFO   : Destroying pgSet object
2003-06-16 13:21:52 INFO   : Creating a pgCollection object
2003-06-16 13:21:52 QUERY  : Set query (test:5432): SELECT d.oid,
d.typname as domname, d.typbasetype, b.typname as basetype,
pg_get_userbyid(d.typowner) as domainowner,
        d.typlen, d.typtypmod, d.typnotnull, d.typdefault, d.typndims,
d.typdelim,
        description
   FROM pg_type d
   JOIN pg_type b ON b.oid = CASE WHEN d.typndims>0 then d.typelem ELSE
d.typbasetype END
   LEFT OUTER JOIN pg_description des ON des.objoid=d.oid
  WHERE d.typtype = 'd' AND d.typnamespace = 132946::oid
  ORDER BY d.typname
2003-06-16 13:21:52 INFO   : Creating pgSet object
2003-06-16 13:21:52 INFO   : Destroying pgSet object
2003-06-16 13:21:52 INFO   : Creating a pgCollection object
2003-06-16 13:21:52 QUERY  : Set query (test:5432): SELECT pr.oid, pr.*,

TYP.typname, lanname, pg_get_userbyid(proowner) as funcowner,
description
   FROM pg_proc pr
   JOIN pg_type TYP ON TYP.oid=prorettype
   JOIN pg_language LNG ON LNG.oid=prolang
   LEFT OUTER JOIN pg_description des ON des.objoid=pr.oid
  WHERE proisagg = FALSE AND pronamespace = 132946::oid
    AND typname <> 'trigger'
  ORDER BY proname
2003-06-16 13:21:52 INFO   : Creating pgSet object
2003-06-16 13:21:52 QUERY  : Set query (test:5432): SELECT oid, typname
FROM pg_type
2003-06-16 13:21:52 INFO   : Creating pgSet object
2003-06-16 13:21:52 INFO   : Destroying pgSet object
2003-06-16 13:21:52 INFO   : Destroying pgSet object
2003-06-16 13:21:52 INFO   : Creating a pgCollection object
2003-06-16 13:21:52 QUERY  : Set query (test:5432): SELECT pr.oid, pr.*,

TYP.typname, lanname, pg_get_userbyid(proowner) as funcowner,
description
   FROM pg_proc pr
   JOIN pg_type TYP ON TYP.oid=prorettype
   JOIN pg_language LNG ON LNG.oid=prolang
   LEFT OUTER JOIN pg_description des ON des.objoid=pr.oid
  WHERE proisagg = FALSE AND pronamespace = 132946::oid
    AND typname = 'trigger'
  ORDER BY proname
2003-06-16 13:21:52 INFO   : Creating pgSet object
2003-06-16 13:21:52 QUERY  : Set query (test:5432): SELECT oid, typname
FROM pg_type
2003-06-16 13:21:52 INFO   : Creating pgSet object
2003-06-16 13:21:52 INFO   : Destroying pgSet object
2003-06-16 13:21:52 INFO   : Destroying pgSet object
2003-06-16 13:21:52 INFO   : Creating a pgCollection object
2003-06-16 13:21:52 QUERY  : Set query (test: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,
        po.proname as operproc, pj.proname as joinproc, pr.proname as
restrproc, description
   FROM pg_operator op
   JOIN pg_type lt ON lt.oid=op.oprleft
   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
   JOIN pg_proc po ON po.oid=op.oprcode
   LEFT OUTER JOIN pg_
2003-06-16 13:21:52 INFO   : Creating pgSet object
2003-06-16 13:21:52 INFO   : Destroying pgSet object
2003-06-16 13:21:52 INFO   : Creating a pgCollection object
2003-06-16 13:21:52 QUERY  : Set query (test:5432): SELECT op.oid, op.*,

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 = 132946::oid
  ORDER BY opcname
2003-06-16 13:21:52 INFO   : Creating pgSet object
2003-06-16 13:21:52 INFO   : Destroying pgSet object
2003-06-16 13:21:52 INFO   : Creating a pgCollection object
2003-06-16 13:21:52 QUERY  : Set query (test: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  = 132946::oid
  ORDER BY relname
2003-06-16 13:21:52 INFO   : Creating pgSet object
2003-06-16 13:21:52 INFO   : Creating a pgSequence object
2003-06-16 13:21:52 INFO   : Destroying pgSet object
2003-06-16 13:21:52 INFO   : Creating a pgCollection object
2003-06-16 13:21:52 QUERY  : Set query (test:5432): SELECT rel.oid,
relname, pg_get_userbyid(relowner) AS relowner, relacl, relhasoids,
relhassubclass, reltuples, description, conname, conkey
   FROM pg_class rel
   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 = 'r') OR (relkind = 's')) AND relnamespace =
132946::oid
  ORDER BY relname
2003-06-16 13:21:52 INFO   : Creating pgSet object
2003-06-16 13:21:52 INFO   : Creating a pgTable object
2003-06-16 13:21:52 INFO   : Creating a pgTable object
2003-06-16 13:21:52 INFO   : Creating a pgTable object
2003-06-16 13:21:52 INFO   : Creating a pgTable object
2003-06-16 13:21:52 INFO   : Creating a pgTable object
2003-06-16 13:21:52 INFO   : Destroying pgSet object
2003-06-16 13:21:52 INFO   : Creating a pgCollection object
2003-06-16 13:21:52 QUERY  : Set query (test:5432): SELECT t.oid, t.*,
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 = 132946::oid
    AND ct.oid IS NULL
  ORDER BY t.typname
2003-06-16 13:21:52 INFO   : Creating pgSet object
2003-06-16 13:21:52 INFO   : Destroying pgSet object
2003-06-16 13:21:52 INFO   : Creating a pgCollection object
2003-06-16 13:21:52 QUERY  : Set query (test:5432): SELECT c.oid,
c.relname, pg_get_userbyid(c.relowner) AS viewowner, c.relacl,
description, pg_get_viewdef(c.oid) AS definition
   FROM pg_class c
   LEFT OUTER JOIN pg_description des ON des.objoid=c.oid
  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 = 132946::oid
  ORDER BY relname
2003-06-16 13:21:52 INFO   : Creating pgSet object
2003-06-16 13:21:52 INFO   : Destroying pgSet object
2003-06-16 13:21:52 INFO   : Displaying properties for schema security
2003-06-16 13:21:52 STATUS : Retrieving Schema details... Done. (0.33
secs)
2003-06-16 13:21:52 INFO   : Displaying properties for Schema security
2003-06-16 13:21:52 STATUS : Retrieving Schema details...
2003-06-16 13:21:52 INFO   : Displaying properties for schema security
2003-06-16 13:21:52 STATUS : Retrieving Schema details... Done. (0.00
secs)
2003-06-16 13:21:57 INFO   : Creating pgConn object
2003-06-16 13:21:57 INFO   : Server name: test (resolved to: 10.0.0.224)
2003-06-16 13:21:57 INFO   : Opening connection with connection string:
hostaddr=10.0.0.224 dbname=mgvd user=postgres port=5432
2003-06-16 13:21:57 INFO   : Setting client_encoding to 'UNICODE'
2003-06-16 13:21:57 INFO   : Creating SQL Query box
2003-06-16 13:21:57 INFO   : Creating a ctlSQLBox
2003-06-16 13:22:01 INFO   : Creating the Query Builder Add Table/View
dialogue
2003-06-16 13:22:01 QUERY  : Set query (test:5432): SELECT a.relname
FROM pg_class a JOIN (SELECT oid,nspname FROM pg_namespace WHERE nspname

<> 'pg_catalog' AND nspname <> 'pg_toast' AND nspname NOT LIKE
'pg_temp_%' ) b ON a.relnamespace = b.oid WHERE a.relkind='r' ORDER BY
lower(a.relname)
2003-06-16 13:22:01 INFO   : Creating pgSet object
2003-06-16 13:22:01 INFO   : Destroying pgSet object
2003-06-16 13:22:01 QUERY  : Set query (test:5432): SELECT a.relname
FROM pg_class a JOIN (SELECT oid,nspname FROM pg_namespace WHERE nspname

<> 'pg_catalog' AND nspname <> 'pg_toast' AND nspname NOT LIKE
'pg_temp_%' ) b ON a.relnamespace = b.oid WHERE a.relkind='v' ORDER BY
lower(a.relname)
2003-06-16 13:22:01 INFO   : Creating pgSet object
2003-06-16 13:22:01 INFO   : Destroying pgSet object
2003-06-16 13:22:04 INFO   : Creating a Query Builder Child Table/View
Frame
---------------END

--
Best regards,

M.

Re: pgadmin III: query builder

От

Jean-Michel POURE

Дата:

17 июня 2003 г., 08:47:16

On Monday 16 June 2003 16:33, Dave Page wrote:
> The program crashes when I
> selected a table (in add table) and clicked OK.

Under GNU/Linux, the query builder crashes at startup.
Cheers, Jean-Michel

Re: pgadmin III: query builder

От

"Dave Page"

Дата:

18 июня 2003 г., 07:10:51

> -----Original Message-----
> From: Jean-Michel POURE [mailto:jm.poure@freesurf.fr]
> Sent: 17 June 2003 09:47
> To: pgadmin-hackers@postgresql.org
> Subject: Re: [pgadmin-hackers] pgadmin III: query builder
>
>
> On Monday 16 June 2003 16:33, Dave Page wrote:
> > The program crashes when I
> > selected a table (in add table) and clicked OK.
>
> Under GNU/Linux, the query builder crashes at startup.

Yes, it's in the bugs list. I've not heard from Keith in some time now
despite a few emails, so unless someone wants to step up and fix the QB,
I will #ifdef it out of the code until someone can look at it (or Keith
returns).

Regards, Dave.

Re: pgadmin III: query builder

От

"Adam H. Pendleton"

Дата:

18 июня 2003 г., 16:04:59

Dave Page wrote:

>Yes, it's in the bugs list. I've not heard from Keith in some time now
>despite a few emails, so unless someone wants to step up and fix the QB,
>I will #ifdef it out of the code until someone can look at it (or Keith
>returns).
>
I will be taking a look at this today.

ahp

Вход в личный кабинет

Восстановление пароля

Подтверждение аккаунта

Изменение пароля

Обсуждение: pgadmin III: query builder