WITH HOLD cursors and transactions in PostgreSQL
by
Laurenz Albe |
10.2021 Both cursors and transactions are basic ingredients for developing a database application. This article describes how cursors and transactions […]
Implementing Autonomous Transactions in Postgres
How to use autonomous transactions in PostgreSQL, with examples. Get insights, use them for logging/ auditing/ progress tracking.
Choose plpgsql variable names wisely
Pavel Stehule recently wrote the post "Don't use SQL keywords as PLpgSQL variable names" describing the situation when internal stored […]
