time server - Search results in mailing lists

2024-02-16 05:45:15 | Re: Reporting UnicodeEncodeError info on arbitrary data sent to PG with psycopg3 (Karl O. Pinc)

server encoding. Even if it means something else to you, it wouldn't hurt to be as specific as possible and write "to the PostgreSQL representation, in the connection's client encoding when this

2023-09-05 17:51:50 | CPU usage for queries, psycopg 2 vs 3 (David Raymond)

servers and run a number of queries on them, where 98% of my machine's time

2023-04-24 21:16:42 | Re: Consecutive Inserts Freeze Execution of Psycopg3 (Michael P. McDonnell)

time I expected (2-3 seconds). So this fundamentally was never about a session, or commits, or anything else; those were working as expected - the query itself was just hung up in the server

2021-02-04 17:31:22 | Re: about client-side cursors (Christophe Pettus)

time you interact with the cursor object, that can be assumed to be an asynchronous operation that can fail due to the remote server

2021-02-04 16:55:21 | Latest developments in psycopg3 (Daniele Varrazzo)

server; trying to use binary parameters makes it even more tricky. The area of the numbers is the most prominent: "select current_date + %s" only works if the parameter is specified as either int2

2021-01-18 14:29:34 | Re: Designing a better connection pool for psycopg3 (Daniele Varrazzo)

server doesn't see the database anymore. This node is arguably broken. If the reconnection thread fails to obtain new connections, and the ones currently in the pool are discarded as detected broken, eventually

2020-12-21 14:24:37 | psycopg3, prepared statements (Daniele Varrazzo)

server are per session, so any form of cache is better connected to the connection than the cursor, although the cursors are the obvious interface to give commands. In the past [1] I thought about

2020-11-09 02:48:54 | Re: psycopg3 and adaptation choices (Vladimir Ryabtsev)

time use '$N' for true server-side binding. Is it an overcomplication or there are valid

2020-03-30 04:27:13 | Re: psycopg3: a first report (Stefan Knecht)

server disappeared or failed over) or does not respond (particularly in the weird cases like when the destination IP just vanishes and the tcp timeout kicks in) - I'd like to know about it within

2019-06-14 00:05:18 | psycopg 2.8.3 released (Daniele Varrazzo)

server graceful shutdown. Psycopg will now make sure that feedback is only sent after a certain period of time

2018-09-26 23:36:38 | Re: Integration of Psycopg with XTA (Christian Ferrari)

server_version:  90324 hver:  d4600100 mem:  030000000000000060ef10f69c7f000000000000000000000000000000000000000000000000000000000000000000000000000000000000e0eccf01000000000000000000000000207cd50100000000007cd501000000000000000000000000000000000000000001000000000000000000000000000000000000000000000003000000d4600100a0bad20100000000b0bed2010000000000000000000000000000000000000000986012f69c7f000000000000000000000000000000000000e08012f69c7f000010f99af19c7f000088fe9af19c7f0000000000000000000000000000000000000000000000000000010000000000000020e78f0000000000e500000000000000ffffffffffffffff ver_off:  264 Traceback (most recent call last):   File "pqconn_hack.py", line 29, in     pqconn = getpqconn(conn)   File "pqconn_hack.py", line 24, in getpqconn     pqconn = htonl

2018-02-27 16:44:29 | Re: About the psycopg2 name (Federico Di Gregorio)

time, all PostgreSQL Python drivers were pure s**t and my company gave to two interns the job to write a new driver. They produced s**t^2 by writing first a server

2017-09-06 14:10:06 | Re: [psycopg] Parse record type into tuple (Daniele Varrazzo)

server to check what type is each field, stores that information, and then uses it at parsing time

2017-08-03 10:00:56 | [psycopg] Feature Request: [PostgreSQL 10] Support for preparing the encrypted password (Ashesh Vashi)

server (done by the 'PQencryptPasswordConn' internally). For PostgreSQL <= 9.6, it will always use the 'PQencryptPassword' function of libpq, and ignores the algorithm. For PostgreSQL 10+, it depends on the libpq version used at compile time

2017-08-02 07:20:44 | [psycopg] psycopg2: distinguishing connect failures through exception handling (Stephen Quintero)

server is up, and separately that it is accessible given a particular user/password/database. This is done using psycopg2.connect(args...). The use case is automated deployment of the docker postgres container, where I wish