[baseten-users] updating of SQL-views

[Tuukka Norri]

Patrick De Visschere kirjoitti 13.2.2010 kello 12.58:
> I was a little bit surprised because I have another example,  more complicated, where it works anyway.
> 
> Suppose I move the dependent column to a separate table (B) with a one-to-one between A and B and the view V now joining A and B.
> In that case the dependent column of B is sometimes updated automatically.
> I can only guess why it sometimes works but not always: apparently a one-to-one relationship is made  (I guess by the assistant) between the view V and one of the underlying tables (A and B). I guess that If this relationship is to the dependent table B, then it's updated; if it is to the main table A, it is not.
> Does this make sense?

Hi!

Can you post the SQL generated by the assistant? I can then try to make a guess on what's going on. Right now I can't think of any cases where this would happen but we'll see.
-- 
Best regards,
Tuukka Norri
MK&C