Clodoaldo Pinto <clodoaldo(dot)pinto(at)gmail(dot)com> writes:
> I've been trying for 3 days to figure out what is happening to no
> avail. What am i missing about transactions and MVCC? What could make
> a plpgsql update function lock a table?
What is the function doing to the table, exactly? DDL changes generally
take exclusive locks ...
regards, tom lane