Re: PostgreSQL 7.2 and SLQ-Ledger 6.x

[Keld S. <ke...@dk...>]

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