cursor - Search results in mailing lists

2023-03-26 16:00:05 | Re: How to get column, table or parameter name reporting when violating DOMAIN type constraint (Tom Lane)

cursors for runtime errors, but it's not apparent to me that that'd be tremendously

2021-10-26 18:47:50 | nested loop joins (Greg Rychlewski)

materialized or are they lazily evaluated? If they are lazily evaluated is it done using cursors? Thanks

2021-08-20 10:38:07 | plpgsql select into (Roger Mason)

cursor CONTEXT: PL/pgSQL function get_info(text) line 3 at RETURN QUERY Perhaps what I'm trying

2020-04-30 17:27:04 | ON CONFLlCT DO UPDATE command cannot affect row a second time (cryptodactyl)

cursor() as cur: upsert = """ INSERT INTO {t} as live ({cols}) ( SELECT {sel_cols} FROM {f} ) """.format

2019-06-13 12:05:55 | Re: ERROR when inserting csv values into sql table (Cravan)

cursor, statement, parameters, context File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7 /site-packages/sqlalchemy/engine/default.py", line 550, in do_execute cursor.execute(statement

2019-06-12 12:13:25 | Re: Error when doing sql (Cravan)

cursor, statement, parameters, context   File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-package s/sqlalchemy/engine/default.py", line 550, in do_execute     cursor.execute(statement

2018-02-14 15:33:02 | WAL settings (J B)

cursor_tuple_fraction = 0.1 # range 0.0-1.0 #from_collapse_limit = 8 #join_collapse_limit = 8 # 1 disables

2015-09-24 13:10:02 | Re: Script and tool to monitoring sessions (amul sul)

cursor mutex x or hw contention or enq TX contention or undo segment extention or log file

2015-04-11 20:35:21 | psql overwrites command line (Malik Rumi)

cursor is blinking at END, but there is no command prompt. I did \q and then

2014-08-13 19:46:05 | Re: tuple compare involving NULL (Merlin Moncure)

cursors. This is a very common way of accessing data for systems converted from the older

2014-01-02 17:33:21 | Re: Passing result of multirow subquery to C function (Merlin Moncure)

cursors you can refer to by string. If you do use the convention: SELECT func

2013-09-07 14:46:41 | Re: Difference in query performance when made from C/C++ client vs. psql client. (Tom Lane)

cursors, something like that? A straight PQexec() of the exact same query string should certainly

2013-03-07 01:49:54 | query on a table with an int and a vector of floating point numbers (Victor Whiskey Yankee)

cursor? Can it be done without the overhead of converting from some serialized form like

2013-02-22 16:26:53 | Re: minimum hardware requirements for small postgres db (Wolfgang Keller)

cursor-animation-syndrome of Windows, however. Honestly, I wouldn't use Ubuntu. For a resource

2013-02-19 01:41:20 | WITH HOLD ref cursors for plpgsql (Daniel Wood)

cursors was once on a TODO list for plpgsql along with scrollable cursors. When scrollable