<br /><br />Strange the rule works for an insertion<br /><br /><br />example:<br /><br /><p>CREATE TABLE public.test<br
/>(<br/>id bigserial NOT NULL,<br />name text<br />);<p><br />ALTER TABLE public.test<br />ADD CONSTRAINT
test_constraint_pkeyPRIMARY KEY(id);<p><br />CREATE TABLE public.v_test<br />(<br />id bigserial NOT NULL,<br />v_id
bigint,<br/>v_name text<br />);<p><br />ALTER TABLE public.v_test<br />ADD CONSTRAINT v_test_constraint_pkey PRIMARY
KEY(id);<p><br/>CREATE OR REPLACE RULE insert AS<br />ON INSERT TO test DO INSERT INTO v_test (v_id, v_name)<br
/>VALUES(new.id, new.name);<p><br /><br /><br />then execute<br /><br /><p>insert into test(name)<br />values <br
/>('1'),<br/>('2'),<br />('3')<br /><br />values in test.id <> v_test.v_id<p>Tested on postgresql 9.5/9.6 install
fromPPA <span data-mce-style="font-family: monospace; font-size: 10.764px; background-color: #f7f7f7;"
style="font-family:monospace; font-size: 10.764px; background-color:
#f7f7f7;">http://apt.postgresql.org/pub/repos/apt</span><br/>OS ubuntu-sever 14.04/16.04<p>Bbest regards<br />Alexander
Pokolenko.<br/>