Dave Page wrote:
-Original Message-
From: Marc Cuypers [mailto:[EMAIL PROTECTED]
Sent: 16 June 2003 10:14
To: [EMAIL PROTECTED]
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.
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
