Hi, I'm upgrading to PostgreSQL 9.5.1 in 64-bit ArchLinux (Linux
4.4.1-2-ARCH) for around 4 days (previously we use 9.4.x), and the
PostgreSQL crashed and make the whole PC down, with this last log from
journalctl:
Mar 09 23:31:17 asd kernel: BUG: Bad page state in process postgres
pfn:d18515
Mar
It would be nice if PostgreSQL has *_extend (similar to $.extend from
jQuery or _.extend from UnderscoreJs) for JSON/JSONB columns, so we could
write it like this:
UPDATE tablename
SET jsoncolumn = json_extend(jsoncolumn, $2)
WHERE id = $1;
instead of this:
UPDATE tablename
SET data = (