Skip to content
New issue

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? Sign in to your account

Sqitch not creating registy tables on first sqitch deploy postgres #562

Open
Doziadele opened this issue Jan 23, 2021 · 2 comments
Open
Labels
waiting Waiting on feedback

Comments

@Doziadele
Copy link

Adding registry tables to db:pg:mydbname
ERROR: syntax error at end of input
LINE 1: SHOW
^
"psql" unexpectedly returned exit value 1

@theory
Copy link
Collaborator

theory commented Jan 23, 2021

Before it creates the registry, Sqitch uses SHOW server_version_num to determine the version it's deploying to:

# Fetch the client version. 8.4 == 80400
my $version = $self->_probe('-c', 'SHOW server_version_num');
my $psql_maj = $self->_psql_major_version;

I can't see why that would be an issue; what version and build of Postgres are you deploying to?

@theory theory added the waiting Waiting on feedback label Apr 3, 2021
@theory
Copy link
Collaborator

theory commented Jun 20, 2022

Did you ever get this issue resolved, @Doziadele?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
waiting Waiting on feedback
Projects
None yet
Development

No branches or pull requests

2 participants