Added the basic transaction functionality for pgsql.
Added basic methods that wrap database/sql functionalities and implement
them with an implied pgsql driver. This architecture is supposedly
scalable to new dialects, but currently only pgsql is supported.