Postgres datetime() error

Derek Atkins warlord at MIT.EDU
Sat May 15 10:34:04 EDT 2004

upgrade to 1.8.9  -- this has LONG since been fixed!


Justin Kamerman <justin at> writes:

> I have GnuCash up and running on RedHat 9.0 with the following packages
> installed
> gnucash-1.8.1-3
> gnucash-backend-postgres-1.8.1-3
> on my front end and Postgres 7.4.2 on the database server. I can save an
> empty account register, ie no accounts, to the database. This creates a
> new database and tables in Postgres as expected. When I add a new
> account and try to save to the database GnuCash complains:
> The server at URL postgres://<mydbserver>/<databasename> experienced an
> error or encountered bad or corrupt data.
> The Postgres log reflects:
> ERROR:  function datetime("unknown") does not exist
> HINT:  No function matches the given name and argument types. You may
> need to add explicit type casts.
> ERROR:  current transaction is aborted, commands ignored until end of
> transaction block
> Does anyone have any suggestions what my problem is or is this perhaps a
> bug ?
> Regards
> Justin Kamerman
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at

       Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
       Member, MIT Student Information Processing Board  (SIPB)
       URL:    PP-ASEL-IA     N1NWH
       warlord at MIT.EDU                        PGP key available

More information about the gnucash-user mailing list