Apr 19, 2023 · Apr 19, 2023 · Apr 19, 2023 · Apr 19, 2023 · Apr 19, 2023
diff --git a/cli/server.go b/cli/server.go
 }

 // Ensure the PostgreSQL version is >=13.0.0!
 version, err := sqlDB.QueryContext(ctx, "SHOWserver_version;")
 version, err := sqlDB.QueryContext(ctx, "SHOWserver_version_num;")
 if err != nil {
 return nil, xerrors.Errorf("get postgres version: %w", err)
 }
 if !version.Next() {
 return nil, xerrors.Errorf("no rows returned for version select")
 }
 varversionStr string
 err = version.Scan(&versionStr)
 varversionNum int
 err = version.Scan(&versionNum)
 if err != nil {
 return nil, xerrors.Errorf("scan version: %w", err)
 }
 _ = version.Close()
 versionStr = strings.Split(versionStr, " ")[0]
 ifsemver.Compare("v"+versionStr, "v13") < 0 {
 return nil, xerrors.New("PostgreSQL version must be v13.0.0 or higher!")

 ifversionNum < 130000 {
 return nil, xerrors.Errorf("PostgreSQL version must be v13.0.0 or higher! Got: %d", versionNum)
 }
 logger.Debug(ctx, "connected to postgresql", slog.F("version",versionStr))
 logger.Debug(ctx, "connected to postgresql", slog.F("version",versionNum))

 err = migrations.Up(sqlDB)
 if err != nil {
Original file line number	Diff line number	Diff line change
Expand Up		@@ -1740,24 +1740,24 @@ func connectToPostgres(ctx context.Context, logger slog.Logger, driver string, d
		}

		// Ensure the PostgreSQL version is >=13.0.0!
		version, err := sqlDB.QueryContext(ctx, "SHOWserver_version;")
		version, err := sqlDB.QueryContext(ctx, "SHOWserver_version_num;")
		if err != nil {
		return nil, xerrors.Errorf("get postgres version: %w", err)
		}
		if !version.Next() {
		return nil, xerrors.Errorf("no rows returned for version select")
		}
		varversionStr string
		err = version.Scan(&versionStr)
		varversionNum int
		err = version.Scan(&versionNum)
		if err != nil {
		return nil, xerrors.Errorf("scan version: %w", err)
		}
		_ = version.Close()
		versionStr = strings.Split(versionStr, " ")[0]
		ifsemver.Compare("v"+versionStr, "v13") < 0 {
		return nil, xerrors.New("PostgreSQL version must be v13.0.0 or higher!")

		ifversionNum < 130000 {
		return nil, xerrors.Errorf("PostgreSQL version must be v13.0.0 or higher! Got: %d", versionNum)
		}
		logger.Debug(ctx, "connected to postgresql", slog.F("version",versionStr))
		logger.Debug(ctx, "connected to postgresql", slog.F("version",versionNum))

		err = migrations.Up(sqlDB)
		if err != nil {
Expand Down