postgres support and missing $ amounts in account detail

Richard Reich rreich@rdrtech.com
20 Nov 2002 15:01:31 -0500


--=-u5tHHbirWHSJcjmWioqj
Content-Type: text/plain
Content-Transfer-Encoding: 7bit

I just tried gnucash with postgres support, following everything in the
readme file.  After saving into the postgres db, quitting, then
reloading all the detials of the accounts had no values in them and I
got this warning in the console I launched gnucash from...

Warning: PrintAmountInternal: Bad numeric.

My environment is Gentoo Linux 1.4, which uses gcc 3.2.
I'm using gnucash 1.6.8 and postgres 7.2.3.  

Attached you will find a trimmed dump of the database.  I hope this
helps.

-Richard Riech

--=-u5tHHbirWHSJcjmWioqj
Content-Type: application/DEFANGED-455; name="gnucash_dump_gz.DEFANGED-455"
Content-Transfer-Encoding: base64
Content-Disposition: attachment; filename="gnucash_dump_gz.DEFANGED-455"

H4sICD3g2z0CA2dudWNhc2guZHVtcADtXW1z4zaS/kz9CpYrVfZcjR28EC9ULlfl8ShZb2bl7Nje
3NbtlQskwRllZMkryUnmfv01SYkgJb4AlKc2VZsZl00RDXQ3ngdAgwCh8/PR+bl/q+c63ujEv7u5
8ieLzWqm12NIGP0jXi4WkOSf+z+v9Cz+OMruQo6d4Gf/+q0v/bMb+IMF4vLVVmCqHvXY/7CI4+Xj
4zKZbT77d5+f4Nbd5Zt3E//m14VejXeFQpbR1fvJ5d1km3xSzXjin428k8rHjf5t409v7vzp/bt3
ryEtfZ7PF6CwSMruZJ/WTyrWDdKPC/24XMzihqR4mVQKSVcq3syWixN/ttjoD3rlv518d3n/7s4/
xQidgsjVcrHerBQk101+ePqkwdAfV7NHBXX0g/7sn1U8eDV69U1jTYYuNXl59W5Xj3kNvp/87eaH
iX/57p2/XOxXYbpaPvo/3r95d331zej795fTuxbBzdI/WeWwnPQL/rwTbHIGo9IbERx4o6CsZ6g3
R1ZssxWc2H748DxLTvz4o8rw0qszSl7VUH1SK90vtS3M8KgptU6QRK/j1eyp4Mju5gYcaqRWO39/
0at1jWeVxKub6e3d+8trwKHi/0PN2qs/Ta5+8M/OKjf9//wv//R0PM50vXrVXk7FrF0phmcHZdTp
viujiexVaFrpjrE9Q/rZXlKjm+ulWDfTa2LdPCelFxIdeAH1tVgX/Ygr1ytZC77nN/p4PFfrzUMG
YDrTILiZQU+4UY9P/q+zzcfl8ya/4//fcqFNdza9+ek0J7Ta6AdoK3rVk7UUflquNxayi+fHnmYT
PwMWi/jI5lGpsgdTYsns7Z0+YldLaSK3waGd2tSNFP30rrGhm+I10W6aH4h2Uz0wXokDr3Qu5kjy
PFNB7/zSspvuE7NqKo8QCBgGlrWw/bzSEP3Es7mulYFfmWazMI2mKtzTFtRj0bFEsw8Z4crS8oji
5Bc1f9YtiXs0zeurkaCmJtsJymyh7KfmFsNuUm6FuulYEeomIi+tD9lhpPRRx5+eljP38MLkdIow
cgoA5KtNd4d7kEcvEvscXSFEJeooObOePT7Ndc6qSM3VIm7j1Uk81xAjJQ89YobkPZJ7vbKp1aPi
jUoxfSHHa7+KCXyyCL6xcOKURfhdIVNP/F2R7AnA9yS7W0k5M8MIH3j0tJrF2rWB5JmKtpFf9rWM
Ls52DPlZA+jtSNfL51WsmyLvsiPN446OjjbRi+Vj+/zOJfTIq8OR340lHIYttg2kKKCpbRis2ukf
2pKln/lblnSTfivUzfeKUCfVCTLWHw5na71eDwjAt9kKum8/9BF+K5ZF4LoWN/C63EcInOvPLOZL
oOlD/d4H6HHXFYYD/R/yGMVyyCgypKnlPOB6+t319Pru76c1ntdJtnOwiWbVOmolGsH2UPVTrcSo
m2ylWDfdamLdhCudwPSwtajNR5hBftQPs+zyYa3/uXXodvLX+8n0qoN+pcRJc0Enfj6o+Rj6pHil
HyFkgutH9VveofkhIZQKgiiXLBCCSST8x9miSMR+XpiPm30Khvlk0R80udHTOzRl6ekr2rJ0A1lB
krV77TxQ7jIWvUdu0eFAs4CGDdCcnbbZv+vt9x5oZWVtO4X9MaAspKmBFma0N03qUhcOuFujbY2x
BbLlDAeTwwEt66O2lZ1dDm+iDQV9wSYqhvnUD1WjG92gNWbphq81S3cTNR0Toe1euzbRMuO2iRZD
e2cTbbK/sYn2hAl7jdYU29hoe8ZT5lI7Dkywxt8adRusufHmcA3k0y9PRTNxhHqXrxHpKm57/fTh
FNtAGjRE4Ds9HTjCZLSvFxYOVdCPp/G9G04j141mXa4bTDMBpbjVkweoPR4MhbTIXQALc361m++N
Xo2up3+avL++u4W6r9rdVu2hs7H2lb+z0g6CnbQdEFXpTjiomSRR2u5hEs0HgwF5q1Aky+dorv2n
lY5nWWDtDArFjiY7QJLbaglILmsJRynbDYaJOylr92zx/KhhDjwYkG3+ApTK45BiISZ/+jGwvVA6
wAEHeErLLSEq5S1hqsl3Q2XiDyraPYWBYDBMkLfabrKAwh0Q5mimAxi5fZZA5LKWIJSy3QCYoCAg
7Z5l4+tgBIqYwEBQi93csRCuFjuAUZhqiUYhbAmHEe7Gw4zrQdDu3Xy23gzGI8u83yT+53/dgQhd
TXUAorDREohC2BIII9wJRGBG9CA83EHxnMw2WXTqPJ6bnE4PP/M1F0hefLBYBy3k9tZWq6Uto5/3
Y+6KRFv0HGCnKrHYV1Kpi56tJRXJnt0le5LdIJtIgeG2bTLDYK7k/XffUpVXwkvtqyoKs18MOujW
KgRp4zl1ZIX1Dio7rtdkrfZSWfPdhFtMtG+DHMT4eu7f69bSIXRgzpXmsIHUihL70pZbSa1pYYJA
Tpt3rAyihMn5xzak/m1IQ6gpnICz3G9kRcmqpMXOI2sqmviXh81r5YOoaHL+scWibYuF69DaXYzt
ZoshtA+dSGK5q8KK9lVJi/0VtrRnZrYhWNem1kHk38//x55n5z3PraRu3Pg8gNMMD2CA095mK34f
ylvvcrbmupl0yfbVgEFEr2VuWpE6XIhqXn8aAiB1dcv+cYgVdHvCdo9DrEEzMwdJe5ZwjoKuUsQx
AL7uW7OyAJQNc9l16coJ3FoWl0Usa6DNXECyzmWh42DeFfAyIPeuhlnALYY47rYo5ga1yWC/PGYN
s4mzpehdYjoO6mohx8LttM5mAXo4tBrcl9vcwK9nclt4syUBN1GnDDuXtY4jwK6Al2nrjSt4/VBz
PMRZt4U8N4hNBvslPWtoTZAVBt2rZMdhW5bwMuB2rw1aoEwH+e24ROiGcyWHw2KhNdImMgt59zLc
cUiXJbxcM25YdbSAmA1y2HHx0Q3iSg6HZUhbiEUZk5H9F0jyrfXP0Wa5UfPyzbGzssZfd82kO9Je
bSvtu/vp1d31zbSdKKXEF7Pk/eTu/v30dvck7PLWP72dvJtc3fkwT5dn6+fHM1CdV9ZF8egVJuD+
9t9372/+4u+SX2dXd2bGWkr9BAyclJ9MacWj6O+zrQTf+l9h/3L69lAqnwJvZerlV5L2claFKk8+
/DeTu58mk6n/Fcly+F/RU//d5fT7+8vvJ/7p+p/z0xaCCEMQ0k6Q7cuIvx+efAmD/q3p0qzSrF0U
j6kWp6eWvJKGV7SdV3n5vydefQmD/uBVF6++BVp9tqZVaGgVHNLqo54/6dXTCgZKgG63gjSQEm2F
tcOpovUZVPKFX2wG/4/M36vd2sXFbn25xPYQ2ssCr9e1jKMmjHM1dXhN/hrulfqvSJgllW/rVpYJ
doBIZABh7YCox83LAbJfmAUgRbMagEiF57aouDanPZlyXcAZmLcQHfvpcrWHEHY/Cuzt5d1lAyij
q5sf/75/5lReZ+tNMlt8M7q+vQkIFuPx/e1b7/7Wf7ucz9XK2972srsyQB5GaPSPi26rietBVb02
l6cHVS1WKZOhICESEdIMoZQgxZVAMo2wlpJ5gqQhixVKFNOEESECzoQMmVCIJJRy781stfmYqM+e
5725nP7g1eoAj0IBZYcq4mmow5QRxYUGl4hCHAdxgrxeC/6sHme6pfS+WqRDjkHqrcnaATXV2hQM
S4KTFGFNNQ2YinGAqKQkxTSlaeIRhMg5xucE+RiNAzZGwQUjYSBYkYSCc8KzJBqOiTD3mI/QOP/x
vLcaxprZxt+vC8ZUkOoUw9wuSbUMlOJxlCRCJSxlUWShnJ0j7GOZJVFk7hEL5ZJjzLHWERIokjRV
LCIyUtk7mwkBi/qVw4/wMRkjMmbY3KNGOUY08N4sI18tEv9HtfH/MpvP1/uWRKkisQLNqYwkSiIM
vIski5nQGtNE9lvCMwwQHyM8JtTcQxVLMAhfqdV8A9SBv8mBFYxjJWVGe01QmGKFSQq1g6XgKE6o
7rdCgFIfhVkS5sYKXAHjJ4i1kpX6Vc331QuJEU6CJJIhJxxIGQQMuMACQmOASNjAQWSuno5p5R6u
wsGJN1k/rWYb12bpeGRTb4PcHtFTbYoJZ5GgiHKa8ChKExbqIKaEZ31LEMeJp4IIs5gDXxVSMVcg
G0Orgb4NURGE2uttT54Xe5AYnmNyTqHhhNuKoYLg7W9oF4EOJIniQIpECZ0STJHSOhCYqADYmIBC
GkB/CNojCbYhsIeniARIYaGJjRmLRjPOCzuKP6M4kdDjwn+EUICkymkQcEQ4FQxx3V8fvU28rT7O
oVff/obhABGlwphRLqIw0URQFgBLMfT3iCLh0YRoiVQSEYbSmDOJWKARfArDAMwNbMxoro/cisII
GmjAhCfQjHU27ggYdKiiSaJDraH36a2L3k6mtS4IDfNfozSIIsA4SgJJOVNJggPMJRAlJRIGxrS/
JiyMaK6JzIbMhL5mygYcaNUfOlVOC6o12L6GgKHyYYDKx6NgjOk4yLpFKnf3so4qu1fri4rzprxz
zPLG8I8p/Ix6Y5pjVBEqOd0q6oXwGEUYZTgWinqDqGMUUShnq6c3mjuq5iTe+dPHTO52iFQvKbdH
+lT52GeCcD3cp9eI8qCXqhmIQXctJMVpjCOGA62IhrFMBmmsEwkEmPxtMr3zzT/v00p90guvUOHt
j/QQ1sgL6IUFPkyh8oKGgks6gm6VR1ihkDKRcsYDGDJ5IEgSh6lAceCqFeILehEwwUiDWgg98sdk
dJRGkshUKxZrmK1gEksEMRPVMhHQU/PU3VlGLyjHdBfCmCQxJlAPCFPMRlInjAQJpyjSNE5iyWOk
oH+mHOIGycih2vny06xRKYWwfczkBYJQSvL9JAkt4oLA2EfIKA6FgiYTIGg4MgrSlED4xSMaMgpD
IQpblK6albIxCS8wlkjwwyQWXGQjLBajGAU4lBF8UDJM4kRzlqKEpxyHaRpGsZun4A6/kIKFnB4m
UXJBgbsMj5BSNE2lJglKI5IFLhFFHHrfBLrDlARunvIxZlCyDCVpUMouJMmWqXubr3Q/Yae/FzEH
wVSbMPa+Xiw3ej0i3tdPcxXrj8t5olcj6n2dbRI9Xzw/jgLv6/KZ4PlskS5HzPt6o347X+m52uik
15/Q/TiSXn8qZ2TU/ekbq8HTvjEWvO8bHaFS+sY1qKW+IWnEPYU5pSQEsvFEpDAv5xLyxlCIVigW
aiQ8JBSlGApBOhQ0SnWMKdNpgrFKoSdAIwI88UioYuA7gRlERDFM5GISMSEgOEcBBHIsk+IeIxkF
mYRYX8MUJBRxFOGEJRpqJAziNJMSXgi6Rcy5FhBhihgCYJXIWKQhURCEct6HeIicDyXpBdwco+Ew
EoZ44IEa1ubsDpOoGhVIj3lwX8J0MwjNNUOVa2auw8r9PofIoCMp7N3JD2NwqWE6+FgGe6PKowdc
DBt2CIG9Ufmr+PW+B3vZ/gcPupjdFS2vgvKKlVe8vBLllSyvwvIKZgflpdGCjRps9GCjCBtN2KiC
9k2Ky1TN1zr7XCYZlcSoJBXHjEpiVBKjkrDqJS0uMQ3EiBgLiNFIjLvEKKdGOTXKaaVajXJqlFOj
nBpt1GijRhs12gKjLTDaAqMtqKBotAVGW2C0BUZbYLQFRhsz2pjRxow2RquXuyqECdWIVThklDOj
nBnlzChnRjk3yrlRzo1ybpRzo41XKGu0caONG23caBNGmzDahNEmjDZhtAmjTVRaiNEmZJ3BwmgX
4V6SsUaiepI01km8l2SszSK5WpKxXtK9JOONNN7ABLcuZbzLgvBakvFW7jVSWekg9ryXxnu55700
3ofG29B4FxpvQmN9aKwPjbWhsS401oRGe1+HzIYdSmLfIxd711zGCD7sXA57k4pzKVxMEgNOqOhf
X6ucn+BijBx0koLtcl+DQb2T+8bJu5AIuigF/3ufavU+X7tcLGbZ22Rq1bZseKyNX3xdsw/VcOB5
AfZLzy+ObOy93Po1iAx4M95uoedlHC/Xu5SnPZj2MZximMnCvC6JmdQ8TZNQqlQjLNOwf0Wgd+m3
bUUAg2nln6MdgfksZjTkPIS5pCSREJqlSQSfkE4EBBa9j9ktHGlZb9p6sv3bzxA84IV1uye57r0w
xH6D3yN22S/w4tzdeP/STQfHGv8v3bRwrPF9j3D6jaf5pof8cTTl1XvG+O9mi2wrpn/1Ua0+aMdh
CCM67JVh6+hrSFM76o1Yx6dGLz5KfvKqj56OLit8ubKqj76OLou9XFkOj94wYsNfonV6ADeEt/y4
Nz+dn8UNsVEMfzHR6bHcF2hXladQR5ZEXqwkajvzhs7/iPcG3ebfQ3gRHvGum9tUvMu6+uto5gvT
JD/cO137xsN8d/3DLPntZGvZ9fTt5L/bN04Xya2l+DfT/R2g97fX0+/9aLPS2j+rbOlve5eu8s1c
DS94FN+DB3PwITbXMm9NLXbF1YysnPfVZqT5GuQwaDNys1oMN3Kbud3I8qycNhMrC5cNJDDfQpB/
t0F+gr2VnffT67/eV8w9LGhrs1kbrdndYbKorLyJXpMHVO1hCcNtNZMs1lC9TedMDrG4rZyt3bWn
WI4cFmZixhve0Ks/DjFncA3xoqusrSd7T25qvpRpbZ6YWHz/TYT6s42Hom0NbZR7ZVTbZoPV5dGC
bVabaF009CGVg8uKr3obYHVTGVurK48BalaXp9C1WV2JI1Hn2FLozW8cOb7slXQ4xjT40dc90iO/
0ut2ctfgxPb1oLXOvkXG7/imp9c+e+1vVs+6rfc+8uuM7M1r/Jab1362lcJY+P+Bq/TEO4AAAA==

--=-u5tHHbirWHSJcjmWioqj
Content-Type: text/sanitizer-log; charset="iso-8859-1"
Content-Transfer-Encoding: 8bit
Content-Disposition: attachment; filename="sanitizer.log"

This message has been 'sanitized'.  This means that potentially
dangerous content has been rewritten or removed.  The following
log describes which actions were taken.

Sanitizer (start="1037822411"):
  Part (pos="728"):
    SanitizeFile (filename="unnamed.txt", mimetype="text/plain"):
      Match (rule="2"):
        Enforced policy: accept

  Part (pos="1316"):
    SanitizeFile (filename="gnucash.dump.gz", mimetype="application/x-gzip"):
      Match (rule="default"):
        Enforced policy: defang

      Replaced mime type with: application/DEFANGED-455
      Replaced file name with: gnucash_dump_gz.DEFANGED-455

  Total modifications so far: 1


Anomy 0.0.0 : Sanitizer.pm
$Id: Sanitizer.pm,v 1.54 2002/02/15 16:59:07 bre Exp $

--=-u5tHHbirWHSJcjmWioqj--