Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Verification always failed for table output Postgresql connection

  1. #1
    Join Date
    Sep 2005
    Posts
    1,403

    Default Verification always failed for table output Postgresql connection

    Hello
    For my first use of KEETLE I observe a strange mistake. It concern the target table for a Postgresql data output connection.

    1- With a target like SCHEMA.TABLE without “ ” the verification’s show sql and running all failed .

    2- With a target like “SCHEMA”.TABLE, Postgresql syntaxes, the verification failed AND the running worked.
    Its seem normal. I just know if I made I mistake? so where?

    and why the verification failed with différent message for the 2 syntaxes ??

  2. #2
    Join Date
    Nov 1999
    Posts
    9,729

    Default RE: Verification always failed for table output Postgresql connection

    Well, if I would have to guess (and I have to because you leave me no other option) then I would think that you created a schema-name with a reserved word. Quoting helps in that particular case.

    Naming a schema SCHEMA and a table "TABLE" would certainly be causing troubles.

    Matt

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.