Re: Potentially undocumented behaviour change in Postgres 11 concerning OLD record in an after insert trigger

2019-01-04 Thread Kristjan Tammekivi
2:56 PM Charles Clavadetscher < clavadetsc...@swisspug.org> wrote: > Hello > > > > *From:* Kristjan Tammekivi > *Sent:* Freitag, 4. Januar 2019 11:46 > *To:* pgsql-gene...@postgresql.org > *Subject:* Potentially undocumented behaviour change in Postgres 11 > concerning

Potentially undocumented behaviour change in Postgres 11 concerning OLD record in an after insert trigger

2019-01-04 Thread Kristjan Tammekivi
Hi, I've noticed a change in the behaviour in triggers / hstores in Postgres 11.1 when compared to Postgres 10.5. The following won't work on Postgres 10.5 but in Postgres 11.1 it works just fine: CREATE EXTENSION hstore; CREATE TABLE _tmp_test1 (id serial PRIMARY KEY, val INTEGER); CREATE TABLE