Re: Using Expanded Objects other than Arrays from plpgsql

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Michel Pelletier <pelletier(dot)michel(at)gmail(dot)com>
Cc: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>, pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Re: Using Expanded Objects other than Arrays from plpgsql
Date: 2024-12-04 00:42:03
Message-ID: 2234661.1733272923@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

Michel Pelletier <pelletier(dot)michel(at)gmail(dot)com> writes:
> Here's a WIP patch for a pgexpanded example in src/test/modules.

I didn't look at your patch yet, but in the meantime here's an update
that takes the next step towards what I promised.

0001-0003 are the same as before, with a couple of trivial changes
to rebase them up to current HEAD. 0004 adds a support function
request to allow extension functions to perform in-place updates.
You should be able to use that to improve what your extension
is doing. The new comments in supportnodes.h explain how to
use it (plus see the built-in examples, though they are quite
simple).

regards, tom lane

Attachment Content-Type Size
v2-0001-Preliminary-refactoring.patch text/x-diff 9.5 KB
v2-0002-Detect-whether-plpgsql-assignment-targets-are-loc.patch text/x-diff 19.3 KB
v2-0003-Implement-new-optimization-rule-for-updates-of-ex.patch text/x-diff 26.3 KB
v2-0004-Allow-extension-functions-to-participate-in-in-pl.patch text/x-diff 17.1 KB

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message PopeRigby 2024-12-04 05:13:42 Re: Errors when restoring backup created by pg_dumpall
Previous Message Adrian Klaver 2024-12-03 20:50:54 Re: Best Practices for Managing Schema Changes Dynamically with libpq

Browse pgsql-hackers by date

  From Date Subject
Next Message Jacob Champion 2024-12-04 00:43:18 Re: Serverside SNI support in libpq
Previous Message John Naylor 2024-12-04 00:15:19 Re: CRC32C Parallel Computation Optimization on ARM