Postgres datetime() error
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 kaleco.net> writes:
> I have GnuCash up and running on RedHat 9.0 with the following packages
> 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 ?
> Justin Kamerman
> gnucash-user mailing list
> gnucash-user at gnucash.org
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
warlord at MIT.EDU PGP key available
More information about the gnucash-user