Foreign key - Indexing & Deadlocking.

Hi,<br /><br />I'm porting some Oracle software to PostgreSQL, & have a question about best practices with foreign
keys.<br/><br />In the Oracle environment, you're basically obliged to index all foreign keys (more specifically
foreignkey columns should appear on the leading edge of an index) due to the way that it manages locks. <br /><br
/>Failureto index foreign keys in this way in Oracle often causes deadlock situations.<br /><br />Although I could no
finda mention of anything similar in the postgreSQL documentation, I just wanted to check whether or not the same was
trueof PostgreSQL to be on the safe side.<br /><br />Thanks,<br /><br />Andrew.<br /><br /><hr />Use Hotmail to send
andreceive mail from your different email accounts. <a href="http://clk.atdmt.com/UKM/go/186394592/direct/01/"
target="_new">Findout how.</a>