manual entry pg_restore
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/15/app-pgrestore.html Description: the manual entry for pg_restore can easily be misinterpreted for the -f option -f filename --file=filename Specify output file for generated script, or for the listing when used with -l. Use - for stdout. This should include a comment that -f does not address the dumpfile to be restored -f filename --file=filename Specify output file for generated script, or for the listing when used with -l. Use - for stdout. This is not to addresse the dump file you want to restore. best regards Gunnar
pl Lua
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/15/external-pl.html Description: Your page, https://www.postgresql.org/docs/15/external-pl.html Please include another, active Lua binding for PostgreSQL. It is https://github.com/arcapos/luapgsql
Re: pl Lua
On 10/17/22 6:03 AM, PG Doc comments form wrote: The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/15/external-pl.html Description: Your page, https://www.postgresql.org/docs/15/external-pl.html Please include another, active Lua binding for PostgreSQL. There is currently a matrix in the wiki that lists out several PL languages[1] and their status. Perhaps we want to consider linking to that from the documentation, given this list may keep changing? Thanks, Jonathan [1] https://wiki.postgresql.org/wiki/PL_Matrix OpenPGP_signature Description: OpenPGP digital signature
https://wiki.postgresql.org/wiki/Meson add info about meson and ninja required version.
Hi, I'm trying to build with meson. --- rm -rf builddir meson setup \ --prefix=/usr/local/pg_master \ -Ddebug=true \ --bindir=/usr/local/pg_master \ --datadir=/usr/local/pg_master \ -Dpgport=1600 \ builddir cd builddir ninja ninja install --- --error part- builddir$ninja install [0/1] Installing files. Installing subdir /home/jian/Desktop/pg_sources/main/postgres/src/include/access to /usr/local/pg_master/include/postgresql/server/access Installation failed due to insufficient permissions. Attempting to use polkit to gain elevated privileges... ERROR: Build directory has been generated with Meson version 0.63.2, which is incompatible with the current version 0.61.2. FAILED: meson-internal__install /home/jian/.local/bin/meson install --no-rebuild ninja: build stopped: subcommand failed. -- Quote from meson.build: > # We want < 0.56 for python 3.5 compatibility on old platforms. EPEL for > # RHEL 7 has 0.55. < 0.54 would require replacing some uses of the fs > # module, < 0.53 all uses of fs. So far there's no need to go to >=0.56. > meson_version: '>=0.54', > Well the error is quite intuitive. Then I tried to install meson 0.61.2. Then all things work as intended. would be better mentioned the meson and ninja required version in https://wiki.postgresql.org/wiki/Meson -- I recommend David Deutsch's <> Jian
Re: JSON/JSONB documentation, aggregate functions
On Tue, Oct 11, 2022 at 11:48:21AM -0400, Bruce Momjian wrote: > On Fri, Sep 16, 2022 at 08:08:04PM +, PG Doc comments form wrote: > > Regarding the Json documentation (9.16.1: processing and creating JSON > > data), I would like to suggest that the reference to > > json_agg/jsonb_agg/json_object_agg/jsonb_object_agg (section 9.21) be made > > more prominent. When looking through the list of json[b] processing > > functions, it's really easy to miss the footnote mentioning the aggregate > > functions. The list of functions in table 9.47 includes a lot of functions > > that are *really*similar in purpose to the json aggregator functions, and > > it's easy to assume that anything related to building JSON[B] objects *must* > > be listed there. I just spent hours searching for a way to turn one column > > of keys and one column of values into a JSONB object (without coercing all > > numeric values to json strings), and I can't imagine I'm the only one. > > I see your point --- that the aggregate sentence is at the end of the > section, after four massive tables. The attached patch moves the > paragraph up to the end of the section's introductory paragraph. Patch applied back to PG 10, thanks. -- Bruce Momjian https://momjian.us EDB https://enterprisedb.com Indecision is a decision. Inaction is an action. Mark Batterson
