Feature request: Add ctid and other functions to pg_proc

[kaspermarstal]

Hi,

PL/Rust's pgproc has additional methods that are obviously useful for procedural language extensions like PL/Rust:

• relation (https://github.com/tcdi/plrust/blob/ff6f46dd00a141e781a121227732b041c4633810/plrust/src/pgproc.rs#L69)
• ctid (https://github.com/tcdi/plrust/blob/ff6f46dd00a141e781a121227732b041c4633810/plrust/src/pgproc.rs#L125)
• heap_tuple (https://github.com/tcdi/plrust/blob/ff6f46dd00a141e781a121227732b041c4633810/plrust/src/pgproc.rs#L79)

Is it possible to add these functions to pgrx's pgrx/src/pg_catalog/pg_proc.rs so they can be used by other procedural language extensions based on pgrx? I imagine this could be useful for PL/Rust as well by avoiding duplicating code. (But perhaps there good reasons that I am unaware of).

[eeeebbbbrrrr]

Ultimately, yeah, it'd be nice to port some version of PL/Rust's PgProc type over to pgrx-proper. There's quite some work happening here right now to shore up pgrx' handling of lifetimes and memory contexts and such. So it'd be hard to guess how much of PL/Rust's existing code would survive v/s needing lots of changes.

That said, we'll at least keep this issue open as a reminder to look at this soon as we can. The pg_proc catalog isn't the only one that would benefit from having a nice wrapper around it. But maybe it can serve as a reference impl to help drive more community contributions around the others.

[workingjubilee]

Is #1545 what you're looking for?

[kaspermarstal]

Thanks for the hint. But as I understand #1545, this also does not expose e.g. ctid.