You absolutely need both. They serve different purposes because transactions provide ACID and advisory locks can be used to provide higher level ordering of app

You absolutely need both. They serve different purposes because transactions provide ACID and advisory locks can be used to provide higher level ordering of application code.