I did encounter a quite strange behavior during update which I did not understand:
The following query updated table parcelle with only one entry for all rows:
update cadastre.parcelle
set code_unique = t2.code_unique from
cadastre.parcelle t1, cadastre.propriete t2
where t1.uoid = t2.uoidparcelle;
the next update query behaved as expected :
update cadastre.parcelle
set code_unique = t2.code_unique from
cadastre.parcelle t1, cadastre.propriete t2
where parcelle.uoid = t2.uoidparcelle;
Why do i have to reference table parcelle in the where clause?