pgdriver: preser order (do not read tx between snapshot xmin-xmax) #77

	# This workflow will build a golang project
	# For more information see: https://docs.github.com/en/actions/automating-builds-and-tests/building-and-testing-go

	name: Go

	on:
	push:
	branches: [ "main" ]
	pull_request:
	branches: [ "main" ]

	jobs:

	build:
	runs-on: ubuntu-latest

	services:
	postgres:
	image: postgres:16
	env:
	POSTGRES_USER: postgres
	POSTGRES_PASSWORD: postgres
	POSTGRES_DB: postgres
	options: >-
	--health-cmd "pg_isready -U user -d testdb"
	--health-interval 10s
	--health-timeout 5s
	--health-retries 5
	ports:
	- 5432:5432

	steps:
	- uses: actions/checkout@v4

	- name: Set up Go
	uses: actions/setup-go@v4
	with:
	go-version: '1.22'

	- name: Build
	run: go build -v ./...

	- name: memdriver tests
	run: go test -v -race ./memdriver/...

	- name: pgdriver tests
	run: \|
	until pg_isready -h 127.0.0.1 -p 5432 -U user; do
	echo "Waiting for Postgres...";
	sleep 3;
	done

	go test -v -race ./pgdriver/...

	- name: flowstate tests
	run: go test -v -race ./

Provide feedback