search

lbehnke / h2database

Automatically exported from code.google.com/p/h2database
0 stars 0 forks source link

Support Squirrel SQL for pgserver #55

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
normal JDBC-based database client tools are not usable against pgserver.
Issue-53 refers to DbVisualizer.

Squirrel is even worst. It basically cannot make any query. Squirrel SQL
verion 2.6.5a and 2.6.9 (current) are tested and both are the same.

There are error messages in the console as follows:
org.postgresql.util.PSQLException: ERROR: Unknown data type: REGPROC; SQL
statement:
SELECT 1 FROM pg_catalog.pg_type WHERE typname = $1 AND
typinput='array_in'::regproc [50004-107]
  Detail: org.h2.jdbc.JdbcSQLException: Unknown data type: REGPROC; SQL
statement:
SELECT 1 FROM pg_catalog.pg_type WHERE typname = $1 AND
typinput='array_in'::regproc [50004-107]
Query 1 of 1 elapsed time (seconds) - Total: 0, SQL query: 0, Building
output: 0
Please try out the Tools popup by hitting ctrl+t in the SQL Editor. Do it
three times to stop this message.

Original issue reported on code.google.com by mingfai...@gmail.com on 1 Feb 2009 at 11:23

GoogleCodeExporter commented 9 years ago 
I have a added a feature request to the roadmap: 
"PostgreSQL compatibility: test DbVisualizer and Squirrel SQL using a new 
PostgreSQL
JDBC driver."

However for me this is not a priority, sorry.

Original comment by thomas.t...@gmail.com on 6 Feb 2009 at 4:45