problmes storing data to postgres

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

problmes storing data to postgres

Andreas Fromm
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi,

Though I'm new to this list, I've been using GncuCash for some years
now and am really happy with it. As need to generate some weird
reports, I would like to insert the data into postgres to generate the
reports via sql-querys. Therefor I compiled gc (1.8.11) with sql
enabled. My problem now is that when I  try to save the data to
postgres, it fails with the following message:
"experienced an error or found bad or corrupted data"

I'm using postgres 8.0, the standard debian packaged version.

I couldn't find any other hint on what is going wrong. The database is
created but no tables are set up. The user has all the rights
available for postgres.

Any help?

Thanks

Andreas Fromm
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (GNU/Linux)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

iD8DBQFDDfEdUmBtSMq5cGURAsPRAKCmfpiFvXVv/LCRGKgqfSIXbgTX2ACggGA2
U2MypuDe0I9AvNEA0+wGMAI=
=B7H4
-----END PGP SIGNATURE-----

_______________________________________________
gnucash-devel mailing list
[hidden email]
https://lists.gnucash.org/mailman/listinfo/gnucash-devel
Reply | Threaded
Open this post in threaded view
|

Re: problmes storing data to postgres

Derek Atkins
Do you have any SXes or Business Objects in your data file?
The PG code is old, crufty, and not recommended..

Also, the last tests were run against PG 7.3.x..  You might want
to downgrade and see if that helps.

-derek

Andreas Fromm <[hidden email]> writes:

> Hi,
>
> Though I'm new to this list, I've been using GncuCash for some years
> now and am really happy with it. As need to generate some weird
> reports, I would like to insert the data into postgres to generate the
> reports via sql-querys. Therefor I compiled gc (1.8.11) with sql
> enabled. My problem now is that when I  try to save the data to
> postgres, it fails with the following message:
> "experienced an error or found bad or corrupted data"
>
> I'm using postgres 8.0, the standard debian packaged version.
>
> I couldn't find any other hint on what is going wrong. The database is
> created but no tables are set up. The user has all the rights
> available for postgres.
>
> Any help?
>
> Thanks
>
> Andreas Fromm
>
> _______________________________________________
> gnucash-devel mailing list
> [hidden email]
> https://lists.gnucash.org/mailman/listinfo/gnucash-devel
>
>

--
       Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
       Member, MIT Student Information Processing Board  (SIPB)
       URL: http://web.mit.edu/warlord/    PP-ASEL-IA     N1NWH
       [hidden email]                        PGP key available
_______________________________________________
gnucash-devel mailing list
[hidden email]
https://lists.gnucash.org/mailman/listinfo/gnucash-devel