[Coursework-help] Postgres 7.3 problems

[Sam O. <sa...@lo...>]

I just joined the list, but I haven't seen a response to the question 
about problems importing the tables on a recent (7.3) version of Postgres.

Recent versions of Postgres have deprecated the column type 'datetime' 
in favor of the more standard 'timestamp'.

---------Quote from 
http://www.postgresql.org/docs/6.3/interactive/c0804.htm----
In future releases, the number of date/time types will decrease, with 
the current implementation of datetime becoming timestamp, timespan 
becoming interval, and (possibly) abstime and reltime being deprecated 
in favor of timestamp and interval. The more arcane features of the 
date/time definitions from the SQL92 standard are not likely to be pursued.
------------------------------------------------------------------------------------

If you are on a *nix system, here is an easy command to change all 
references of 'datetime' to 'timestamp':

find ./ -name \*sql |xargs perl -pi -e 's/datetime/timestamp/g'

Do older version of Postgres also support the timestamp column type?  
Would there be any harm in changing the SQL files in CVS to comply with 
new versions of Postgres?  Would we be losing backward-compatability?

Sam