A B escribió: > Hi. newbie question, but what will happen if I do > > begin work; > select ... > insert ... > and so on... > commit > > and somewhere a query fails. will I get an automatic rollback? Of course. -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster