[BUGS] Segmentation fault with JSONB column from view passed into storedPL/PGSQL procedure that builds a new JSON return value - Mailing list pgsql-bugs
From
Samuel Horwitz
Subject
[BUGS] Segmentation fault with JSONB column from view passed into storedPL/PGSQL procedure that builds a new JSON return value
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.
At this point everything works. Selecting from the second view is fine.
However, if I alter the stored procedure's resulting JSON in any way, this will cause selecting from the second view to trigger a segfault.
The solution is easy: regenerate the second view by just CREATE OR REPLACEing it with the existing definition.
From:
samuel.horwitz@gmail.com Date: Subject:
[BUGS] BUG #14876: Segmentation fault with JSONB column used in store procthat gets used by view and later altered
Есть вопросы? Напишите нам!
Соглашаюсь с условиями обработки персональных данных
✖
By continuing to browse this website, you agree to the use of cookies. Go to Privacy Policy.