I'm building some functions in plpgsql, and I got to a point where I thought: How are transactions used in the function? Is it posible to rollback the modifications that were made to the tables at some point in the plpgsql function?
-- 09:58:01 up 10 days, 14:29, 4 users, load average: 0.11, 0.31, 0.32 ----------------------------------------------------------------- Martín Marqués | select 'mmarques' || '@' || 'unl.edu.ar' Centro de Telematica | DBA, Programador, Administrador Universidad Nacional del Litoral ----------------------------------------------------------------- ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match