Re: Segmentation fault with JSONB column from view passed into stored PL/PGSQL procedure that builds a new JSON return value

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Samuel Horwitz <samuelhorwitz(at)gmail(dot)com>
Cc: "pgsql-bugs(at)postgresql(dot)org" <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: Segmentation fault with JSONB column from view passed into stored PL/PGSQL procedure that builds a new JSON return value
Date: 2017-10-26 20:23:03
Message-ID: CAKFQuwZb6g+-HyUpWCkqq-TbDCxBn4N4kbmLmAFbrxeeFviL_g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Thu, Oct 26, 2017 at 11:26 AM, Samuel Horwitz <samuelhorwitz(at)gmail(dot)com>
wrote:

> Postgres Version: 9.6.5
>
> I have a table that includes a JSONB column. I have a view that is based
> on this table that reflects this JSONB column. I have yet another view,
> based on the first view, that passes rows from the first view into a stored
> PL/PGSQL procedure as anyelement. This stored procedure builds a JSON
> object from it's input and returns that new JSON object. One of the values
> on the new JSON object is the value of the JSONB column that has gone
> through two views by this point, into the procedure.
>
>
​Duplicate of Bug # 14876​

David J.

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2017-10-26 20:42:36 Re: BUG #14876: Segmentation fault with JSONB column used in store proc that gets used by view and later altered
Previous Message Michael Paquier 2017-10-26 19:24:06 Re: BUG #14876: Segmentation fault with JSONB column used in store proc that gets used by view and later altered