It's probably also worth pointing out that plpgsql doesn't exist in template1 unless you (or whoever is the DB admin) has put it there - doing that is a convenience so you don't have to do it whenever you create a new DB that will use plpgsql, but isn't part of the default PG configuration...
