Re: 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.