Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Sign up
Appearance settings

pg_pathman breaks pg_repack #118

Closed
Closed
Labels
Milestone
@tarvip

Description

Steps to reproduce:

postgres@ip-10-1-1-68:~$ createdb foo
postgres@ip-10-1-1-68:~$ psql foo -c "create table t(a bigint primary key, b text);"
CREATE TABLE
postgres@ip-10-1-1-68:~$ psql foo -c "create extension pg_repack"
CREATE EXTENSION
postgres@ip-10-1-1-68:~$ pg_repack -t t -d foo
INFO: repacking table "t"
postgres@ip-10-1-1-68:~$ psql foo -c "create extension pg_pathman"
CREATE EXTENSION
postgres@ip-10-1-1-68:~$ pg_repack -t t -d foo
INFO: repacking table "t"
ERROR: query failed: ERROR: SET TRANSACTION ISOLATION LEVEL must be called before any query
DETAIL: query was: BEGIN ISOLATION LEVEL SERIALIZABLE
postgres@ip-10-1-1-68:~$ psql foo -c "drop extension pg_pathman"
DROP EXTENSION
postgres@ip-10-1-1-68:~$ pg_repack -t t -d foo
INFO: repacking table "t"
postgres@ip-10-1-1-68:~$

postgres version 9.5.8
pg_pathman 1.4.3
pg_repack 1.4.0.1

Metadata

Metadata

Assignees

No one assigned

    Labels

    Type

    No type

    Projects

    No projects

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions

      AltStyle によって変換されたページ (->オリジナル) /