Re: Problem generating sql with postgres

From: Greg Hulands (ghuland..ac.com)
Date: Wed Apr 09 2008 - 18:43:11 EDT

  • Next message: Mike Schrag: "Re: Problem generating sql with postgres"

    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:43:51 EDT