[GENERAL] PostgreSQL crashed, whole PC not responding

2016-03-09 Thread Kiswono Prayogo
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

[GENERAL] Feature Request: json_extend, jsonb_extend

2014-12-17 Thread Kiswono Prayogo
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 = (