main.go

package main

import (
	"database/sql"
	"fmt"

	_ "github.com/lib/pq"
)

func main() {
	db, err := sql.Open("postgres", "")
	if err != nil {
		panic(err)
	}
	defer db.Close()

	tx, err := db.Begin()
	if err != nil {
		panic(err)
	}

	// if you execute these in psql in a transaction, you get a rollback
	query := `set local statement_timeout = '1s';
	select pg_sleep(10)`

	_, err = tx.Exec(query)
	if err != nil {
		tx.Rollback()
		fmt.Println("timed out")
	} else {
		tx.Commit()
		fmt.Println("failed to time out")
	}
}