Re: Fwd: Retour sur Insert

--000000000000e80815056e9965ba
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

Merci pour ton aide.

donc  migration =C3=A0 prevoir :-)

Pierre.

Le jeu. 14 juin 2018 =C3=A0 13:38, Vik Fearing <[email protected]=
> a
=C3=A9crit :

> On 14/06/18 13:08, Pierre BOIZOT wrote:
> >
> > =E2=80=8BHello Vik,
> >
> > J'obtiens le message suivant
> > ERROR:  cannot insert into view "test"
> > HINT:  You need an unconditional ON INSERT DO INSTEAD rule or an INSTEA=
D
> > OF INSERT trigger.
> > ef=3D#=E2=80=8B
>
> Ooh l=C3=A0. Tu sais que les versions ant=C3=A9rieures =C3=A0 la 9.3 ne s=
ont plus
> support=C3=A9es ? Il faut vite mettre tout =C3=A7a =C3=A0 jour !
>
> > =E2=80=8BC'est comme si le trigger sur la table ne s'appliquait pas=E2=
=80=8B.
>
> C'est surtout que l'INSERT n'atteint pas la table.
> --
> Vik Fearing                                          +33 6 46 75 15 36
> http://2ndQuadrant.fr     PostgreSQL : Expertise, Formation et Support
>

--000000000000e80815056e9965ba
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div class=3D"gmail_default" style=3D"font-family:verdana,=
sans-serif;font-size:small">Merci pour ton aide.</div><div class=3D"gmail_d=
efault" style=3D"font-family:verdana,sans-serif;font-size:small"><br></div>=
<div class=3D"gmail_default" style=3D"font-family:verdana,sans-serif;font-s=
ize:small">donc=C2=A0 migration =C3=A0 prevoir :-)<br clear=3D"all"></div><=
div><div dir=3D"ltr" class=3D"gmail_signature" data-smartmail=3D"gmail_sign=
ature"><div dir=3D"ltr"><div><div dir=3D"ltr"><br>Pierre.<br></div></div></=
div></div></div></div><br><div class=3D"gmail_quote"><div dir=3D"ltr">Le=C2=
=A0jeu. 14 juin 2018 =C3=A0=C2=A013:38, Vik Fearing &lt;<a href=3D"mailto:v=
[email protected]">[email protected]</a>&gt; a =C3=A9cri=
t=C2=A0:<br></div><blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .=
8ex;border-left:1px #ccc solid;padding-left:1ex">On 14/06/18 13:08, Pierre =
BOIZOT wrote:<br>
&gt; <br>
&gt; =E2=80=8BHello Vik,<br>
&gt; <br>
&gt; J&#39;obtiens le message suivant<br>
&gt; ERROR:=C2=A0 cannot insert into view &quot;test&quot;<br>
&gt; HINT:=C2=A0 You need an unconditional ON INSERT DO INSTEAD rule or an =
INSTEAD<br>
&gt; OF INSERT trigger.<br>
&gt; ef=3D#=E2=80=8B<br>
<br>
Ooh l=C3=A0. Tu sais que les versions ant=C3=A9rieures =C3=A0 la 9.3 ne son=
t plus<br>
support=C3=A9es ? Il faut vite mettre tout =C3=A7a =C3=A0 jour !<br>
<br>
&gt; =E2=80=8BC&#39;est comme si le trigger sur la table ne s&#39;appliquai=
t pas=E2=80=8B.<br>
<br>
C&#39;est surtout que l&#39;INSERT n&#39;atteint pas la table.<br>
-- <br>
Vik Fearing=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=
=A0 =C2=A0 +33 6 46 75 15 36<br>
<a href=3D"http://2ndQuadrant.fr" rel=3D"noreferrer" target=3D"_blank">http=
://2ndQuadrant.fr</a>=C2=A0 =C2=A0 =C2=A0PostgreSQL : Expertise, Formation =
et Support<br>
</blockquote></div>

--000000000000e80815056e9965ba--