cursor - Search results in mailing lists

2025-06-21 23:01:03 | Re: BUG #18960: Mistake in test test_simple_pipeline (libpq_pipeline.c) (Tom Lane)

cursor_one CURSOR FOR SELECT 1"); + + res = PQexec(conn, "BEGIN"); + if (PQresultStatus(res) != PGRES_COMMAND

2025-05-04 00:50:04 | Re: BUG #18909: Query creates millions of temporary files and stalls (Sergey Koposov)

cursor query. So summarizing: the query produces millions of files in 1) query through cursor

2025-04-08 10:10:11 | BUG #18882: Unexpected write skew at SERIALIZABLE with psycopg2.connect() (PG Bug reporting form)

cursor() cur2 = conn2.cursor() try: cur1.execute("SET SESSION CHARACTERISTICS AS TRANSACTION ISOLATION LEVEL SERIALIZABLE

2025-03-21 15:58:54 | Re: BUG #18859: ERROR: unexpected plan node type: 356 (Andrei Lepikhov)

cursors code which inserts Material node: if (cursorOptions & CURSOR_OPT_SCROLL) { if (!ExecSupportsBackwardScan(top_plan

2024-10-06 21:08:25 | Re: Server crash when selecting from pg_cursors (Tom Lane)

cursor() is assuming portal->sourceText can't be NULL: values[1] = CStringGetTextDatum(portal->sourceText); which

2024-09-09 08:04:48 | BUG #18605: cursor select not working (PG Bug reporting form)

cursor CURSOR FOR SELECT * FROM example; FETCH all FROM my_cursor;-------------------i have execute the script

2024-07-15 16:07:40 | Re: BUG #18531: err when using 'current of' with incremental COMMIT (Tom Lane)

cursor [1], and after that there is not an active cursor query for the WHERE

2024-07-12 09:31:48 | BUG #18534: ERROR: portal "C_n" does not exist type of error getting thrown. (PG Bug reporting form)

cursor is open or closed, ensuring the database connection object is active, and confirming the prepared

2024-07-05 12:49:27 | cursor direction for a foreign scan that reached the fetch_size (MOVE BACKWARD ALL IN cX) (Etsuro Fujita)

cursor query contains FOR UPDATE: as discussed in [1], the cursor would be idempotent if later

2024-05-09 21:56:34 | Re: relfrozenxid may disagree with row XIDs after 1ccc1e05ae (Melanie Plageman)

CURSOR FOR SELECT * FROM foo; FETCH FORWARD FROM c1; step 3: PRIMARY SESSION A: -- INSERT

2024-05-01 17:25:35 | Re: BUG #18433: Logical replication timeout (Kostiantyn Tomakh)

cursor() # Function to generate fake data for one row def generate_fake_row(): fake = Faker

2024-03-06 16:00:00 | Re: BUG #18374: Printing memory contexts on OOM condition might lead to segmentation fault (Alexander Lakhin)

cursor_parse_open (name=name@entry=0x0, src=src@entry=0x563eacbf2c58 "explain analyze execute stmt

2024-03-04 07:19:33 | BUG #18375: requested statistics kind "f" is not yet built for statistics object 16722 (PG Bug reporting form)

cursor_tuple_fraction = 1.0, max_prepared_transactions = 100, and higher memory settings / resource limits. The database

2024-02-02 03:10:03 | Undetected deadlock between primary and standby processes ()

CURSOR FOR SELECT * FROM generate_series(1, 1000000) n ORDER BY n; FETCH mycur; SELECT

2023-11-24 04:00:01 | Re: BUG #17828: postgres_fdw leaks file descriptors on error and aborts aborted transaction in (Alexander Lakhin)

cursor_$i CURSOR FOR SELECT * FROM ft_$i;"; done echo "SELECT * INTO nt FROM ft_1 UNION