Suppose I have defined an additional type in a PG extension.
Is it possible to add custom accessors to that type -much like jsonb does- but
use an API/hook without touching the core PG grammar & parser?
Hypothetical Examples:
Assuming I have a TextFile type I’d like to implement syntax like:
Carsten Klein writes:
> @Tom Lane: you say, PostgreSQL does not / cannot change rounding mode at
> any time? There is no function to do so? So, the script (it's more like
> a module) must provide a Shared Object module with a C function in order
> to change the FPU's rounding mode?
Per grep, t
On 19.02.2022 15:35, Tomas Pospisek wrote:
That would be visible via `lsof`. `libc. The file `...libc...so` that
`postgres` is keeping open would have the text `DEL` (as in deleted) in
the `FD` column of `lsof`'s output.
As opposed to a newly started program which would have `REG` (regula
Hello everyone,
I’m building an open-source data integration tool (SQLpipe) and am now trying
to incorporate CDC into the product.
Is it possible to detect when schema changes happen via the WAL? The WAL
doesn’t have to tell me what was changed, it just needs to tell me when
something changed.
On Sat, Feb 19, 2022 at 8:35 AM Tomas Pospisek wrote:
>
> On 18.02.22 22:42, Peter J. Holzer wrote:
>
> > If there has been a glibc update (or a postgresql update) in those 480
> > days (Ubuntu 14.04 is out of its normal maintenance period but ESM is
> > still available) the running processes may
On 18.02.22 22:42, Peter J. Holzer wrote:
If there has been a glibc update (or a postgresql update) in those 480
days (Ubuntu 14.04 is out of its normal maintenance period but ESM is
still available) the running processes may well run different code than
a newly started program. So it could be a
