reproduce-bug.sh

application/x-shellscript

Filename: reproduce-bug.sh

Type: application/x-shellscript

Part: 1

Message: If a row-level security policy contains a set returning function, pg_dump returns an incorrect serialization of that policy if the return type of the function was altered

#!/usr/bin/env bash

DB="timos_weird_example"
RESTORED_DB="timos_weird_example__restored"

# create a clean test environment
dropdb --if-exists $DB
dropdb --if-exists $RESTORED_DB
createdb $DB
createdb $RESTORED_DB

# apply schema
psql $DB < schema.sql

# then dump this schema
pg_dump $DB > dumped-schema.sql

# then restore this schema
psql $RESTORED_DB < dumped-schema.sql