psycopg2

psycopg2 copied to clipboard

Replace deprecated unittest aliases

1

https://docs.python.org/3/library/unittest.html#deprecated-aliases

hugovk

switch to pkg-config to find out the information about libpq

8

pg_config was meant for building server extensions.

darix

options='-c statement_timeout=5000' not honoured with SSL timeout

4

We hung over 15 minutes, despite there being a statement timeout in effect of 5 seconds. Connect call: psycopg2.connect( dbname = databaseName, user = userName, host = hostName, port =...

stefanknechtDBE

unable to roll over quickly with multiple hosts in green mode

3

Using psycopg2, I find it's unable that if you provide mutliple hosts to connect to and fail quickly over unconnectable hosts. For example, if I specify four hosts, host1,2,3,4 in...

zhangyangyu

Linking issue with static libpq compilation

6

I'm currently building an app using [buildozer], i've patched it to compile the version 10.12 of libpq. Their recipe for compiling psycopg2 compiles against the static lib of libpq which...

Progdrasil

Literal `%` in queries should always be escaped.

1

Currently in psycopg a lone `%` is accepted when the query has no parameters, but must be doubled into `%%` if the query takes parameters. This is confusing because changing...

dvarrazzo

Abort in GC on exit

9

I have a large long running (many hours) process which is started daily. When it terminates, I see this on the screen on which it was started (even though I...

sam-s

added helpful executemany & execute_batch examples

2

hopefully this will make those functions more approachable for newbies. everyone tries it without proper sequences and then has to google.

kannes

sql Identifer, Literal should double-escape `%`

1

Related to #824, Identifiers and literals containing a `%` don't go through a round of escaping and end up messing up the parameters. ```python >>> import psycopg2 >>> from psycopg2...

dvarrazzo

Mogrify performance on arrays

5

Originally submitted by: ChrisB If I run cursor.mogrify on a 64000 double array it is taking 350ms. If I just do a 'ARRAY[' + ','.join(map(str, array)) + ']' and put...

psycoteam