Re: Problem generating sql with postgres

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

  • Next message: Greg Hulands: "Re: Problem generating sql with postgres"

    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:36:15 EDT