If you keep getting a runtime error along the lines of "datetime(unknown) function not
found", the datetime stuff has been depreciated in PostgreSQL 7.3.x... I fixed it by
changing the file backends/postgres/kvp-sql.c, in the macro CPY_KVP(TYPE).
Line 532 currently reads:
p = stpcpy (p, "' as sessionGuid, datetime('NOW') as date_changed, " \
change it to read:
p = stpcpy (p, "' as sessionGuid, now() as date_changed, " \
This fixed the problem for me... hope it helps you.
Thanks,
Fernando Vilas
[EMAIL PROTECTED]
--
__________________________________________________________
Sign-up for your own FREE Personalized E-mail at Mail.com
http://www.mail.com/?sr=signup
_______________________________________________
gnucash-devel mailing list
[EMAIL PROTECTED]
http://www.gnucash.org/cgi-bin/mailman/listinfo/gnucash-devel
