connects - Search results in mailing lists

2024-12-21 13:45:45 | Memory (Vladimir Ryabtsev)

connect(cs, cursor_factory=psycopg.ClientrCursor) as conn: with conn.cursor('my_table') as cur: cur = cur.execute

2024-12-09 17:14:30 | Re: Best Practices for Checking PostgreSQL Server Mode with Multiple Connections (Christophe Pettus)

connect, you also query to see what servers are attached to that server as binary

2024-02-14 01:37:32 | Reporting UnicodeEncodeError info on arbitrary data sent to PG with psycopg3 (Karl O. Pinc)

Connect to an existing database with psycopg.connect("dbname=test_latin1 user=test") as conn

2024-01-07 16:09:55 | New releases, and happy new year! (Daniele Varrazzo)

Connecting to multiple hosts can also be implemented at DNS level, by associating more than

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

connect(host = "localhost", dbname = "...", user = "...", password = "...", autocommit = True) with conn.cursor() as cur: cur.execute

2023-07-20 20:39:46 | Re: conn.read_only not honored in autocommit mode (Daniele Varrazzo)

connect("", options="-c default_transaction_read_only=true", autocommit=True) >>> conn.execute("create table foo ()") Traceback

2022-10-17 11:25:14 | Puzzling situation with threads and psycopg2 on RDS (Stefan Knecht)

CONNECT Thread-2 CONNECT Thread-2 Run plan <<'Create basic order'>> Thread-2 Processing query

2022-04-04 22:02:40 | cur.execute() syntax error (Rich Shepard)

connect(database='bustrac') # the cursor cur = con.cursor() def __init__(self, parent, *args, **kwargs): super

2022-03-19 13:43:19 | Re: Query with boolean parameter (Daniele Varrazzo)

connect(autocommit=True) In [5]: cnn.execute("create table dist (id int primary key, cond

2021-10-11 18:01:09 | psycopg3 transactions (Paolo De Stefani)

connect() with con.transaction(): with con.cursor() as cur: cur.execute("INSERT INTO table VALUES

2021-10-03 15:33:43 | Re: psycopg3 and cur.description behavior (Daniele Varrazzo)

connect` or `select * from pa_connect` you get different results: a table with a single

2021-02-07 15:50:39 | libpq pipeline/batch mode (Daniele Varrazzo)

reconnect to the recent conversation about it). However I am getting stretched pretty thinly with

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

Connecting oid catalog and adaptation contexts The next changes in the adaptation area will be around

2021-02-04 11:16:47 | Re: about client-side cursors (Denis Laxalde)

connect(autocommit=False) async with conn: cur = await conn.execute("SELECT 1") rows = await cur.fetchall

2021-01-18 18:20:12 | Re: Designing a better connection pool for psycopg3 (Vladimir Ryabtsev)

connect? At pool initialization or on first "getconn()"? Following connection attempts may be repeated, with