Postgres 7.3.2 datetime bug

Fernando Vilas fvilas at
Thu Feb 6 11:10:32 CST 2003

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.

Fernando Vilas
fvilas at
Sign-up for your own FREE Personalized E-mail at

More information about the gnucash-devel mailing list