Thanks all...ended up being a missing field in my table definition...sorry to bother you all ... :wistle: -- View this message in context: http://www.nabble.com/Trigger---will-not-perform-INSERT-tp14282848p14297220.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match