Re: Problem generating sql with postgres

From: Mike Schrag (mschra..dimension.com)
Date: Wed Apr 09 2008 - 18:49:45 EDT

  • Next message: Bill Michell: "Eclipse update sites"

    ... yeah :) It's generating generic sql and not using the plugin at
    all, basically.

    On Apr 9, 2008, at 6:43 PM, Greg Hulands wrote:

    > I should have actually tried to import the sql into psql - errors
    > galore.
    > On Apr 9, 2008, at 3:35 PM, Greg Hulands wrote:
    >> Thanks Mike, no exception now. What part of the sql generated is
    >> not correct? On a quick once over it looks right.
    >>
    >> greg
    >>
    >>
    >> On Apr 9, 2008, at 3:18 PM, Mike Schrag wrote:
    >>>> I am trying to generate the sql for the model and get the
    >>>> exception below. In the dialog it complains that "Unable to find
    >>>> type information for external type 'decimal' in attribute
    >>>> 'amount' of entity 'DiscountRule'. Check spelling and
    >>>> capitalization."
    >>> You know, I get this from the postgresql amount prototype as
    >>> well ... Anjo does not, and I'm not sure why. If I change the
    >>> prototype definition from "decimal" to "numeric" (which is
    >>> supposed to be an alias of "decimal") it works properly. This
    >>> must be version differences or something. Try changing the
    >>> definition of the decimal postgresql prototypes in ERPrototypes to
    >>> numeric also and see if that works for you?
    >>>
    >>> Oh, you're 5.4 ... Postgresql is not going to generate proper SQL
    >>> in 5.4, probably. This isn't fixed until the next WO release.
    >>>
    >>> ms
    >>>
    >>
    >



    This archive was generated by hypermail 2.0.0 : Wed Apr 09 2008 - 18:50:35 EDT