procedures - Search results in mailing lists

2024-12-05 17:33:16 | Formal Syntax of PL/pgSQL (PG Doc comments form)

procedures. While exploring the official documentation, I noticed that commands like CREATE TABLE or SELECT

2024-11-03 16:58:00 | Re: Tip box on Adding a Column (jian he)

PROCEDURE log_rewrite(); create table t1(a int); insert into t1 select 1; alter table

2024-09-07 21:57:08 | Re: retrieving results of procedures with OUT params (ch.l.ngre)

Procedures do not return a function value; hence CREATE PROCEDURE lacks a RETURNS clause. However

2024-07-12 13:15:20 | Re: Savepoints in plpgsql (David G. Johnston)

procedure transactions chapter. Namely by explaining why the last limitation on that page exists, which

2024-05-20 21:07:55 | 52.38 pg_proc (postgresql version 14) (PG Doc comments form)

procedure, a for an aggregate function, or w for a window function. However, there "f" is used

2024-03-17 02:16:42 | Monetary Data Types Improvement (PG Doc comments form)

procedure with a negative numeric value for money causes an error. The solution to this

2024-01-17 15:53:34 | Supplement of procedure suggested (PG Doc comments form)

procedure to handle the "database is not accepting commands" situation, see "Instead, follow these steps

2023-11-24 11:04:09 | INFORMATION_SCHEMA.routine_column_usage (Erki Eessaar)

procedure. This information is currently not tracked by PostgreSQL." However, this claim is incorrect because

2023-06-01 16:41:56 | Re: pass open cursor via USING in execute staement (Lorusso Domenico)

procedure (must be already open? must be declared in some specific way?) Il giorno gio 1 giu 2023 alle

2023-02-15 18:59:20 | February 9th, 2023 Release links to a missing page (Kirk Wolak)

procedure*.html" and I believe it should be "sql-create*function*.html" Side Note: On such

2022-10-27 19:45:09 | Cursor Names are "Session Global while Opened"? (should be mentioned in the docs) (PG Doc comments form)

procedure. Then while that cursor is OPEN, I call ANOTHER procedure that (anywhere down the callstack

2022-09-24 15:14:42 | Re: Do blocks support transaction control? (Laurenz Albe)

procedure code cannot execute transaction control statements. Transaction control statements are only allowed if DO is executed

2022-05-31 18:47:23 | Re: Can we still dump version 7? (Jonathan S. Katz)

Could we add as part of the branching procedure that we update this value? Jonathan

2022-04-05 18:59:53 | Re: Improve documentation for pg_upgrade, standbys and rsync (Bruce Momjian)

procedure _somewhere_ --- if we don't the only procedure is embedded in a tool. and that

2022-03-05 10:15:33 | Missing tags ALTER ROUTINE and DROP ROUTINE in Event Trigger Firing Matrix (PG Doc comments form)

PROCEDURE" and "ALTER FUNCTION" tags (respectively "DROP PROCEDURE" and "DROP FUNCTION" tags). Best regards, -- Leslie