> Hi all, quick question related to some scalability problems I have been seeing: do foreign key references acquire write locks on the row they are referencing during an insert, and are these locks held until the end of the transaction?
>
> Thanks,
>
> Shawn
>