Re: [HACKERS] duplicated partial-column assigns allowed by checkInsertTargets

2014-12-04 Thread Jim Nasby
On 12/4/14, 2:23 PM, Alvaro Herrera wrote: While perusing checkInsertTargets I noticed that it allows duplicated assignments to the same member of a composite: alvherre=# create type f as (a int, b int); CREATE TYPE alvherre=# create table t (col f); CREATE TABLE alvherre=# insert into t (col.a,

[HACKERS] duplicated partial-column assigns allowed by checkInsertTargets

2014-12-04 Thread Alvaro Herrera
While perusing checkInsertTargets I noticed that it allows duplicated assignments to the same member of a composite: alvherre=# create type f as (a int, b int); CREATE TYPE alvherre=# create table t (col f); CREATE TABLE alvherre=# insert into t (col.a, col.b, col.a) values (42, 43, 44); INSERT 0