You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@sqoop.apache.org by "Davide Grohmann (Created) (JIRA)" <ji...@apache.org> on 2012/02/24 15:32:48 UTC

[jira] [Created] (SQOOP-445) Wrong query for getListColumnsQuery in PostgresqlManager

Wrong query for getListColumnsQuery in PostgresqlManager
--------------------------------------------------------

                 Key: SQOOP-445
                 URL: https://issues.apache.org/jira/browse/SQOOP-445
             Project: Sqoop
          Issue Type: Bug
          Components: connectors/postgresql
    Affects Versions: 1.4.0-incubating, 1.4.1-incubating
         Environment: PostgreSQL 9.1
            Reporter: Davide Grohmann


When querying for column available in a postgres table from postgres catalog, it returns also the dropped columns from the table in object. It can be easily fixed adding the extra constraint "AND col.ATTISDROPPED = 'f'" at the end of the query which sort out the dropped columns.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira