From: pmichalek at click.cz (=?ISO-8859-2?Q?Petr_Mich=E1lek?=) Date: Sun, 08 Jun 2008 22:06:56 +0200 Subject: [Pljava-dev] Possible bug, when updating BigDecimal from trigger/function Message-ID: <484C3BE0.8010406@click.cz> Hello, When PL/Java trigger/function is updating BigDecimal, scale of new BigDecimal value is not checked. Because of this, is possible store in database numeric value with greater precision than is in column definition. In result of this behavior sql dump can contains values with greater precision and subsequent import fails on affected tables. Please can anybody confirm this behavior and is possible to fix this. Best regards. Petr Michalek