Re: PostgreSQL & NULL values

From: Andrus Adamchik (andru..bjectstyle.org)
Date: Fri Oct 14 2005 - 21:40:18 EDT

  • Next message: Kevin Menard: "Re: Cayenne 1.2 + PostgreSQL"

    I am running DataContextClobTst from Cayenne test suite against
    PostgreSQL 8 on Mac. Here is null insert and it works:

    CREATE TABLE CLOB_TEST (CLOB_COL text NULL, CLOB_TEST_ID integer NOT
    NULL, PRIMARY KEY (CLOB_TEST_ID))
    ...
    INSERT INTO CLOB_TEST (CLOB_COL, CLOB_TEST_ID) VALUES (?, ?)
    QueryLogger: [bind: NULL, 204]

    One last thing I can recommend is upgrade the driver. If this doesn't
    work, open a bug report with your test code.

    Andrus

    On Oct 14, 2005, at 9:16 PM, Kevin Menard wrote:

    > On Fri, 14 Oct 2005 20:57:32 -0400, Andrus Adamchik
    > <andru..bjectstyle.org> wrote:
    >
    >
    >> So ... What is the type of this column on PostgreSQL end? "text"
    >> or "varchar"?
    >>
    >
    > The type mapping is "text" and appears to have been for a long
    > time. Checking the DB schema, it is indeed a "text" data type.
    >
    > --
    > Kevin

    This archive was generated by hypermail 2.0.0 : Fri Oct 14 2005 - 21:40:22 EDT