get a relations DDL server-side

I would like to introduce the ability to get object DDL (server-side) by introducing a new function with roughly the following prototype: get_ddl(regclass) RETURNS text LANGUAGE C STRICT PARALLEL SAFE; A previous conversation seemed to encourage the development of this feature https://www.postg

WIP: raise error when submitting invalid ALTER SYSTEM command

way of editing the autoconf file (which says "# Do not edit this file manually!" on its first line). The attached WIP patch is intended to raise an error on invalid ALTER SYSTEM commands before being written out to the filesystem. Hopefully this behavior is more intuitive. Thanks -- Jor

add the source of param misconfigurations to error messages

o 10 in $path$ and max_connections is set to 10 in $path$) Alternatively, we can track alter system changes in the postgresql.conf, so we have a unified source of parameter configurations. Thanks! -- Jordan Deitch https://id.rsa.pub/

Re: Delta Materialized View Refreshes?

propagate correctly to the MV. -- Jordan Deitch https://id.rsa.pub/

Table renaming does not propagate to views

e to test; insert into public.test(id) values ('12/12/2010'); select * from public.test_v; <-- (erroneously) returns 1 rollback; ------- Thanks! -- Jordan Deitch https://id.rsa.pub/

Re: Proposal: Adding json logging

> Exactly what are you logging here ??? Why would I need to see a > multi-dimensional array in the log ? If I wanted to capture the location of errors my clients are encountering on their postgres clusters in detail, I would need to parse the 'LOCATION' string in their log entries, parse out th

Re: Proposal: Adding json logging

> > I would suggest that the community consider whether postgres will log > multidimensional data. That will weigh into the decision of json vs. > another format quite significantly. I am a fan of the json5 spec ( > https://json5.org/), though adoption of this is quite poor. > > What do you mean

Re: Proposal: Adding json logging

I would suggest that the community consider whether postgres will log multidimensional data. That will weigh into the decision of json vs. another format quite significantly. I am a fan of the json5 spec (https://json5.org/), though adoption of this is quite poor. --- Jordan Deitch https

pearltidy source code has been removed (pgindent)

Hi hackers, I am unable to build pgindent as it appears the pearltidy source has been removed from sourceforge: see prerequisite 2: https://git.postgresql.org/gitweb/?p=postgresql.git;a=blob_plain;f=src/tools/pgindent/README;hb=HEAD Thanks, Jordan Deitch