cursor - Search results in mailing lists
Mailing lists >> pgsql-general >> Thread
2025-04-27 08:44:34 | Re: How to get the data from the query (Igor Korot)
cursors name | text | | | pg_file_settings name
Mailing lists >> pgsql-general >> Thread >> Search in thread (3)
2025-02-13 22:11:15 | Re: psql command line editing (Ron Johnson)
cursor keys when in emacs mode. Our servers are RHEL, my ssh client emulates xterm
Mailing lists >> pgsql-general >> Thread >> Search in thread (4)
2025-01-06 14:54:41 | Re: Will PQsetSingleRowMode get me results faster? (Dominique Devienne)
cursor instead of a statement allows you to reduce your time-to-first-row. But at the expense
Mailing lists >> pgsql-general >> Thread
2025-01-04 02:22:03 | Re: search_path for PL/pgSQL functions partially cached? (Jan Behrens)
cursors, but that didn't turn out to work very smooth either. Instead, I plan
Mailing lists >> pgsql-general >> Thread >> Search in thread (10)
2024-12-25 01:23:04 | Re: Intermittent errors when fetching cursor rows on PostgreSQL 16 (Enrico Schenone)
cursors in two versions: 1. 4Js Genero BDL language 2. pure C with libpq language
Mailing lists >> pgsql-general >> Thread
2024-12-18 18:11:54 | Re: Intermittent errors when fetching cursor rows on PostgreSQL 16 (Ron Johnson)
cursors? See https:///docs/current/plpgsql-cursors.html#PLPGSQL-CURSOR-USING Section 41.7.3.5. -- Death to , and butter sauce. Don't boil me, I'm still
Mailing lists >> pgsql-general >> Thread
2024-11-18 21:57:18 | Re: work_mem RAM Accounting in PostgreSQL (Laurenz Albe)
cursor. Yes, it is up to the C library to keep some free'd memory
Mailing lists >> pgsql-general >> Thread
2024-11-16 19:09:29 | Re: Getting error 42P02, despite query parameter being sent (Adrian Klaver)
cursor() cur.execute("CREATE VIEW public.foobar (alg, hash) AS VALUES ('md5', %s)", ['test']) IndeterminateDatatype
Mailing lists >> pgsql-general >> Thread
2024-10-15 06:39:19 | Re: How to Copy/Load 1 billions rows into a Partition Tables Fast (Muhammad Usman Khan)
cursor() query = f""" INSERT INTO partitioned_table (column1, column2, ...) SELECT column1, column2, ... FROM source_table
Mailing lists >> pgsql-general >> Thread >> Search in thread (2)
2024-10-07 18:15:48 | Get cursor name for invalid_cursor_name error (PetSerAl)
cursor name which cause invalid_cursor_name error? postgres=# CREATE FUNCTION value_from_cursor_unsafe
Mailing lists >> pgsql-general >> Thread
2024-09-30 13:08:54 | Trouble in generating the plpgsql procedure code (Nikhil Ingale)
CURSOR IS SELECT table_name,test_table_name FROM app_tables WHERE TEST_TABLE_NAME
Mailing lists >> pgsql-general >> Thread
2024-09-21 22:15:44 | Re: How batch processing works (Adrian Klaver)
cursor() csr.execute("drop table if exists parent_table") csr.execute("create table parent_table
Mailing lists >> pgsql-general >> Thread
2024-07-16 00:37:31 | Re: Dropping column from big table (Peter J. Holzer)
cursor() for i in range(100): csr.execute("UPDATE tab set id = id WHERE id % 100 = %s", (i,)) conn
Mailing lists >> pgsql-general >> Thread
2024-04-11 07:41:56 | RE: (When) can a single SQL statement return multiple result sets? (Patrick FICHE)
CURSORS... RETURNS SETOF REFCURSOR Then, in your function, you have to write something like this
Mailing lists >> pgsql-general >> Thread
2024-04-09 16:33:27 | [MASSMAIL]PL/pgSQL techniques better than bash for dynamic DO? (Ron Johnson)
CURSOR FOR SELECT $Field, ${Table}_id from ${FQTable} where $Field < (${DtCol} - interval ${Thresh}); BEGIN FOR arow