Hitachi Vantara Pentaho Community Forums
Results 1 to 1 of 1

Thread: is of type boolean but expression is of type character varying

  1. #1
    Join Date
    Mar 2007
    Posts
    216

    Smile is of type boolean but expression is of type character varying

    Hi,

    I have a table mytable with a field myfield with type=boolean.
    I don't manage to feed it :
    I have a step "Add Constant" with name=myfield, type=boolean and value=false followed by a step "Table Output" with table=mytable
    The error is :
    Code:
    Prepared statement : INSERT INTO mytable(myfield) VALUES (?)
    Error inserting row into table [mytable] with values: [N]
    ERROR: column "myfield" is of type boolean but expression is of type character varying.
    Configuration : Kettle v3.0.0.GA Windows XP Pro SP2 PostgreSQL v7.4. Any idea ? I did not manage to reproduce it without a db.

    a+, =)
    -=Clément=-
    ......................................
    edit
    ......................................
    I tried to change the type in my PostgreSQL Db from boolean to character varying(1) so that the N can be written.
    That did not work :
    Code:
    ...is of type characte varying[] but expression is of type character varying
    Last edited by clement; 11-20-2007 at 02:01 PM.

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.