We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and
privacy statement. We’ll occasionally send you account related emails.
Already on GitHub?
to your account
Flyway 5.0.7 community
(Many bugs are fixed in newer releases and upgrading will often resolve the issue)
(Please include the content causing the issue, any relevant configuration settings, the SQL statement that failed (if relevant) and the command you ran.)
We are trying to create a PG logical replication setup.
As part of this setup, on the server where data is to replicated, we need to run the following statement, after the database model is created:
CREATE SUBSCRIPTION ifdb_subscription CONNECTION 'host=xxx.xxx.xxx.xxx dbname=xxxx user=xxxx password=xxxx port=5432' PUBLICATION ifdb_publication;
A successful migration message, just like for other migrations.
SQL State : 25001
Error Code : 0
Message : ERROR: CREATE SUBSCRIPTION ... WITH (create_slot = true) cannot run inside a transaction block
The text was updated successfully, but these errors were encountered:
Added notes for flyway/flyway#1992
Good catch! This has now been fixed for both CREATE SUBSCRIPTION and DROP SUBSCRIPTION.
Sorry, something went wrong.
Fixed flyway#1992: CREATE SUBSCRIPTION PostgreSQL statement not detec…
…ted as non-transactional
No branches or pull requests