execute - Search results in mailing lists
Mailing lists >> psycopg >> Thread
2025-04-26 03:25:47 | Python 3.14, template-strings, and psycopg (Daniele Varrazzo)
execute(t"select * from mytable where id = {value}") I have started to think about a few details
Mailing lists >> psycopg >> Thread >> Search in thread (2)
2024-12-21 13:45:45 | Memory (Vladimir Ryabtsev)
execute(query) while True: rows = cur.fetchmany(batch_size) # ... if not rows: break The code
Mailing lists >> psycopg >> Thread
2024-12-08 15:45:34 | Best Practices for Checking PostgreSQL Server Mode with Multiple Connections (YoungUk Song)
execute the pg_is_in_recovery() function for each connection to determine the mode. I’m curious
Mailing lists >> psycopg >> Thread >> Search in thread (3)
2024-12-06 04:27:43 | Parameter in SQL query being misinterpreted (Daniel Johnson)
executing an SQL statement and am not sure if it's a fundamental issue with
Mailing lists >> psycopg >> Thread
2024-11-01 13:17:47 | TypeError: dict is not a sequence (thiemo@gelassene-pferde.biz)
execute("set postgis.gdal_enabled_drivers = 'ENABLE_ALL';") root, dirs, files = next(os.walk(data
Mailing lists >> psycopg >> Thread >> Search in thread (4)
2024-09-08 00:59:41 | Re: psycopg2: proper positioning of .commit() within try: except: blocks (Karsten Hilbert)
execute(SQL) curs.close() conn.commit() conn.close() Written more safely: conn = psycopg2.connection() curs
Mailing lists >> psycopg >> Thread
2024-04-22 16:34:40 | Safe SELECT ... LIKE abc% in psycopg (Philippe Strauss)
execute("""SELECT myco.genus.name FROM myco.genus WHERE myco.genus.name LIKE %s""", (genus
Mailing lists >> psycopg >> Thread
2024-04-08 16:49:42 | [MASSMAIL]pgcopy 1.6.0 release announcement (Aryeh Leib Taurog)
type * mixed-case table and column names * proper handling of exceptions in threaded copy execution
Mailing lists >> psycopg >> Thread >> Search in thread (3)
2024-02-14 14:30:33 | Re: Reporting UnicodeEncodeError info on arbitrary data sent to PG with psycopg3 (Daniele Varrazzo)
execute("set client_encoding to 'latin1'") >>> dumper = conn.adapters.get_dumper(str, psycopg.adapt.PyFormat
Mailing lists >> psycopg >> Thread
2023-11-20 22:46:21 | Re: 2-to-3 Question about adapter using AsIs (Daniele Varrazzo)
execute using the classic `mogrify()`: >>> cur = psycopg.ClientCursor(conn) >>> cur.mogrify("INSERT INTO tbl (f1, f2) VALUES
Mailing lists >> psycopg >> Thread
2023-09-05 17:51:50 | CPU usage for queries, psycopg 2 vs 3 (David Raymond)
execute("select pg_sleep(15);") conn.close() def connectAndRunSleep2(): conn = psycopg2.connect(host = "localhost", dbname
Mailing lists >> psycopg >> Thread >> Search in thread (2)
2023-07-20 20:39:46 | Re: conn.read_only not honored in autocommit mode (Daniele Varrazzo)
execute("create table foo ()") Traceback (most recent call last) ... ReadOnlySqlTransaction: cannot execute CREATE TABLE in a read
Mailing lists >> psycopg >> Thread >> Search in thread (10)
2023-04-23 20:45:56 | Consecutive Inserts Freeze Execution of Psycopg3 (Michael P. McDonnell)
execute(query, qparams) When I run the queries in dbeaver - the first query takes 120s
Mailing lists >> psycopg >> Thread
2022-11-01 16:22:46 | Error while trying to install in 3.11 (David Raymond)
executable not found. pg_config is required to build psycopg2 from source. Please add the directory
Mailing lists >> psycopg >> Thread
2022-10-17 11:25:14 | Puzzling situation with threads and psycopg2 on RDS (Stefan Knecht)
execute : BEGIN 2022-10-17 10:59:03 UTC:10.0.1.17(36350):postgres@postgres:[31908]:LOG: execute