summaryrefslogtreecommitdiff
path: root/src/tutorial/basics.source
diff options
context:
space:
mode:
authorTom Lane <tgl@sss.pgh.pa.us>2017-07-11 16:48:59 -0400
committerTom Lane <tgl@sss.pgh.pa.us>2017-07-11 16:48:59 -0400
commit521fede166d6d8ce0c7745c169ad7c0ea49233c9 (patch)
tree805acbe72d7914c68321d527ad29da4f071cb520 /src/tutorial/basics.source
parent59892b1209b9202338dbfc65c9a59cbed182befb (diff)
Fix multiple assignments to a column of a domain type.
We allow INSERT and UPDATE commands to assign to the same column more than once, as long as the assignments are to subfields or elements rather than the whole column. However, this failed when the target column was a domain over array rather than plain array. Fix by teaching process_matched_tle() to look through CoerceToDomain nodes, and add relevant test cases. Also add a group of test cases exercising domains over array of composite. It's doubtless accidental that CREATE DOMAIN allows this case while not allowing straight domain over composite; but it does, so we'd better make sure we don't break it. (I could not find any documentation mentioning either side of that, so no doc changes.) It's been like this for a long time, so back-patch to all supported branches. Discussion: https://postgr.es/m/4206.1499798337@sss.pgh.pa.us
Diffstat (limited to 'src/tutorial/basics.source')
0 files changed, 0 insertions, 0 deletions