Re: document json[b] limitation

2018-04-25 Thread Oleg Bartunov
On Wed, Apr 25, 2018 at 2:12 AM, Tom Lane wrote: > Oleg Bartunov writes: >> Attached is a small patch, which documents the maximum size of >> json[b] types. Probably, it's worth to patch previous releases, where >> the types were introduced. > > If you said "maximum size is 1GB", period, I'd beli

Re: document json[b] limitation

2018-04-25 Thread Oleg Bartunov
On Wed, Apr 25, 2018 at 6:50 PM, Oleg Bartunov wrote: > On Wed, Apr 25, 2018 at 2:12 AM, Tom Lane wrote: >> Oleg Bartunov writes: >>> Attached is a small patch, which documents the maximum size of >>> json[b] types. Probably, it's worth to patch previous releases, where >>> the types were introd

Re: how does jsonb_set work?

2018-04-25 Thread Bruce Momjian
On Sun, Apr 15, 2018 at 01:45:22PM +, PG Doc comments form wrote: > The following documentation comment has been logged on the website: > > Page: https://www.postgresql.org/docs/10/static/functions-json.html > Description: > > the documentation is missing some information > > how does the js

Re: document json[b] limitation

2018-04-25 Thread Michael Paquier
On Wed, Apr 25, 2018 at 06:50:51PM +0300, Oleg Bartunov wrote: > Oops, it should be 256 Mb :) The numbers you are presenting are right, aka 1GB for json: =# create table aa (a json); CREATE TABLE =# insert into aa select ('{"key":"' || repeat('a', 512 * 1024 * 1024) || repeat('a', 500 * 1024