Re: Add notification on BEGIN ATOMIC SQL functions using temp relations

Jim Jones <jim.jones@uni-muenster.de>

From: Jim Jones <jim.jones@uni-muenster.de>

To: Tom Lane <tgl@sss.pgh.pa.us>

Cc: "David G. Johnston" <david.g.johnston@gmail.com>, Pavel Stehule <pavel.stehule@gmail.com>, PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>

Date: 2025-10-13T15:49:31Z

Lists: pgsql-hackers

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

Improve detection of implicitly-temporary views.
- 698fa924b11a 19 (unreleased) landed
Issue a NOTICE if a created function depends on any temp objects.
- 572c40ba94ef 19 (unreleased) landed

Attachments

v5-0001-Refactor-dependency-recording-to-enable-dependenc.patch (text/x-patch) patch v5-0001
v5-0002-Prevent-SQL-functions-with-BEGIN-ATOMIC-from-depe.patch (text/x-patch) patch v5-0002


On 10/13/25 17:16, Jim Jones wrote:
> PFA a first attempt to address your points.

Oops... wrong files. Sorry.
PFA the correct version.

Jim