|
From: Keld S. <ke...@dk...> - 2002-03-07 15:05:35
|
On Thu, Mar 07, 2002 at 04:20:38PM +0100, Jonas Smedegaard wrote: > Hi all, > > I just upgraded to PostgreSQL 7.2 and ran into trouble. > > I believe I solved the problem and want to share it with you (sorry if it > is already covered somewhere): > > The sql dumps had lines like the following > > "transdate" date DEFAULT 'current_date' > > which PostgreSQL 7.2 dislikes. > > A simple search and replace did the trick: > > s/'current_date'/CURRENT_DATE/ I get a lot of errors invalid command \N invalid command \. And after doing your recommended change I get: ERROR: Bad date external representation 'CURRENT_DATE' I really would like some advise on this. I had no problems with upgrading to postres 7.1.3 but going to 7.2 has not worked for me yet. Keld |