AWS redshift error : generateChangeLog

General Discussion
1

I am running generateChangeLog command
db: aws redshift

[2022-03-11 00:37:00] SEVERE [liquibase.integration] Error executing SQL SELECT replace(CAST(conrelid::regclass as text), n.nspname || '.','') AS TABLE_NAME, conname as CONSTRAINT_NAME,  replace(pg_get_constraintdef(c.oid),'CHECK ','') as SEARCH_CONDITION, 'ENABLED' AS STATUS FROM pg_constraint c  JOIN   pg_namespace n ON n.oid = c.connamespace   WHERE  contype IN ('c') AND n.nspname = 'finance'  AND conrelid <> '-'::regclass  ORDER  BY conrelid::regclass::text, contype DESC: ERROR: cannot cast type regclass to character varying
liquibase.exception.CommandExecutionException: liquibase.exception.LiquibaseException: Unexpected error running Liquibase: liquibase.exception.DatabaseException: Error executing SQL SELECT replace(CAST(conrelid::regclass as text), n.nspname || '.','') AS TABLE_NAME, conname as CONSTRAINT_NAME,  replace(pg_get_constraintdef(c.oid),'CHECK ','') as SEARCH_CONDITION, 'ENABLED' AS STATUS FROM pg_constraint c  JOIN   pg_namespace n ON n.oid = c.connamespace   WHERE  contype IN ('c') AND n.nspname = 'finance'  AND conrelid <> '-'::regclass  ORDER  BY conrelid::regclass::text, contype DESC: ERROR: cannot cast type regclass to character varying
        at liquibase.command.CommandScope.execute(CommandScope.java:163)
        at liquibase.integration.commandline.CommandRunner.call(CommandRunner.java:51)
        at liquibase.integration.commandline.CommandRunner.call(CommandRunner.java:21)
        at picocli.CommandLine.executeUserObject(CommandLine.java:1953)
        at picocli.CommandLine.access$1300(CommandLine.java:145)
        at picocli.CommandLine$RunLast.executeUserObjectOfLastSubcommandWithSameParent(CommandLine.java:2352)
        at picocli.CommandLine$RunLast.handle(CommandLine.java:2346)
        at picocli.CommandLine$RunLast.handle(CommandLine.java:2311)
        at picocli.CommandLine$AbstractParseResultHandler.execute(CommandLine.java:2179)
        at picocli.CommandLine.execute(CommandLine.java:2078)
        at liquibase.integration.commandline.LiquibaseCommandLine.lambda$execute$1(LiquibaseCommandLine.java:325)
        at liquibase.Scope.child(Scope.java:189)
        at liquibase.Scope.child(Scope.java:165)
        at liquibase.integration.commandline.LiquibaseCommandLine.execute(LiquibaseCommandLine.java:291)
        at liquibase.integration.commandline.LiquibaseCommandLine.main(LiquibaseCommandLine.java:80)

it seems to work with Liquibase Open Source but when using pro the error occurs
the liquibase.hub.mode=OFF

2

Hi @mohsink Thanks for reporting this. Do you have functions or procedures in your Redshift database? I think there may be a bug in the Pro code for this.