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

Reply via email to