diff options
| author | Andrew Gierth <rhodiumtoad@postgresql.org> | 2017-06-28 19:00:55 +0100 |
|---|---|---|
| committer | Andrew Gierth <rhodiumtoad@postgresql.org> | 2017-06-28 19:00:55 +0100 |
| commit | 8c55244ae379822d8bf62f6db0b5b1f7637eea3a (patch) | |
| tree | 3f2afebbcbab046dace68bf6d5f8d1e65fab1437 /contrib/postgres_fdw | |
| parent | c46c0e5202e8cfe750c6629db7852fdb15d528f3 (diff) | |
| download | postgresql-8c55244ae379822d8bf62f6db0b5b1f7637eea3a.tar.gz postgresql-8c55244ae379822d8bf62f6db0b5b1f7637eea3a.zip | |
Fix transition tables for ON CONFLICT.
We now disallow having triggers with both transition tables and ON
INSERT OR UPDATE (which was a PG extension to the spec anyway),
because in this case it's not at all clear how the transition tables
should work for an INSERT ... ON CONFLICT query. Separate ON INSERT
and ON UPDATE triggers with transition tables are allowed, and the
transition tables for these reflect only the inserted and only the
updated tuples respectively.
Patch by Thomas Munro
Discussion: https://postgr.es/m/CAEepm%3D11KHQ0JmETJQihSvhZB5mUZL2xrqHeXbCeLhDiqQ39%3Dw%40mail.gmail.com
Diffstat (limited to 'contrib/postgres_fdw')
0 files changed, 0 insertions, 0 deletions