sql-ledger-users

PostgreSQL 7.2 and SLQ-Ledger 6.x

[Jonas S. <dr...@jo...>]

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/


 - Jonas

-- 
Jonas Smedegaard (+45 40843136)          http://dr.jones.dk/~jonas/
Spiff ApS (= IT-guide dr. Jones ApS)     http://dr.jones.dk/
Debian GNU/Linux developer               http://people.debian.org/~js/

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

Re: PostgreSQL 7.2 and SLQ-Ledger 6.x

[Jonas S. <dr...@jo...>]

On Thu, 7 Mar 2002, Keld Jørn Simonsen wrote:

> > 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'

My guess is you did this:

s/'current_date'/'CURRENT_DATE'/

instead of this:

s/'current_date'/CURRENT_DATE/

Notice the difference? Remove the quotes as well. :-)

 - Jonas

-- 
Jonas Smedegaard (+45 40843136)          http://dr.jones.dk/~jonas/
Spiff ApS (= IT-guide dr. Jones ApS)     http://dr.jones.dk/
Debian GNU/Linux developer               http://people.debian.org/~js/