Not sure if this is a bug in pgAdmin or PG, but thought I'd mention it
as it's "weird" and easy to check.
Using pgAdmin 3 (both v1.0.2 and 1.1.0dev as of 23rd June), if I connect
to a PG 7.4.3 database and go to the
"information_schema.constraint_column_usage" view, pgAdmin3 shows the
SQL definition for this view in the window.
If I cut-n-paste this definition into a SQL editing window and tell it
to execute, I get the error:
ERROR: syntax error at or near "ALL" at character 1353
Looking at the SQL that was shown in the SQL editing window, it appears
to not be correct. In this case it's missing a closing ")" which
generates the above error.
First time I've noticed anything like this with pgAdmin3, and it's
happening on two different platforms... version 1.0.2 on Sun Java
Desktop System Release 2, and version 1.1.0 dev (latest downloadable) on
Regards and best wishes,
pgadmin-support by date
|Next:||From: Ramesh Yeligar||Date: 2004-07-02 04:30:00|
|Subject: pgsql db|
|Previous:||From: Dave Page||Date: 2004-07-01 08:08:17|
|Subject: Re: [pgadmin-support] PGAdmin3 crashes on adding tables to Querybuilder|