Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Compatibility with various programming languages #188

Open
NoyException opened this issue Nov 21, 2024 · 3 comments
Open

Compatibility with various programming languages #188

NoyException opened this issue Nov 21, 2024 · 3 comments
Labels
compatibility Be compatible with some old fashion request

Comments

@NoyException
Copy link
Contributor

NoyException commented Nov 21, 2024

c (using libpq-fe): ok

Java (using postgresql JDBC):

Exception in thread "main" java.lang.RuntimeException: org.postgresql.util.PSQLException: The server's standard_conforming_strings parameter was reported as postgres. The JDBC driver expected on or off.

Php (using php-pgsql): Numbers are garbled

   ...
   Running test: CREATE TABLE test.tb1 (id int, value float, c1 char(10), primary key(id))
   Returns 0 rows
   Running test: INSERT INTO test.tb1 VALUES (1, 1.1, 'a'), (2, 2.2, 'b')
   Returns 0 rows
   Running test: SELECT * FROM test.tb1
   Expected: 1, 1.1, a, got: 0, ?���, a

Python (using psycopg2): fixed

@NoyException NoyException added the compatibility Be compatible with some old fashion request label Nov 21, 2024
@VWagen1989
Copy link
Contributor

VWagen1989 commented Nov 21, 2024

I will try to fix the issue faced by psycopg2 now.

@VWagen1989
Copy link
Contributor

VWagen1989 commented Nov 21, 2024

@NoyException Which version of psycopg2 did you use for the test? I ran the test with psycopg2-2.9.10 and the connection was established as expected.

@NoyException
Copy link
Contributor Author

@NoyException Which version of psycopg2 did you use for the test? I ran the test with psycopg2-2.9.10 and the connection was established as expected.

This bug was found yesterday, and now I find it fixed in the newest version. Thank you for your attention.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
compatibility Be compatible with some old fashion request
Projects
None yet
Development

No branches or pull requests

2 participants