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 1
alvherre=# select * from t;
col
---------
(44,43)
(1 fila)
If you instead try a duplicate "col", it is rightfully rejected:
alvherre=# insert into t (col, col) values ((42, 43), (44, 43));
ERROR: column "col" specified more than once
LÍNEA 1: insert into t (col, col) values ((42, 43), (44, 43));
^
Isn't this a bit odd?
--
Álvaro Herrera http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services