Uploaded image for project: 'Red Hat Fuse'
  1. Red Hat Fuse
  2. ENTESB-16286

Syndesis doesn't show PostgreSQL demo data procedures

    XMLWordPrintable

Details

    Description

      When I select PostgresDB connection (created when demoData: true) and Invoke stored procedure step, there are no procedures in the dropdown, even though the DB contains it:
      ```
      sampledb=# \df sampledb.*
      List of functions
      Schema | Name | Result data type | Argument data types | Type
      ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
      sampledb | add_lead | void | first_and_last_name character varying, company character varying, phone character varying, email character varying, lead_source character varying, lead_status character varying, rating character varying | func
      sampledb | create_lead | SETOF record | OUT first_name text, OUT last_name text, OUT company text, OUT lead_source text | func
      (2 rows)
      ```
      There are no related error in the server/meta pod.
      I have tried to create another function manually ( https://github.com/syndesisio/syndesis-qe/blob/1.12.x/rest-tests/src/test/resources/features/integration-database.feature#L37 ) but it didn't show up either.

      Attachments

        Activity

          People

            cmiranda@redhat.com Claudio Miranda
            mkralik@redhat.com Matej Kralik
            Matej Kralik Matej Kralik
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: