Re: SQL-Ledger on PostgreSQL question

[Gary P. <ga...@es...>]

I got this error when I first installed SQL-Ledger.  The cause of the
problem wasn't anything like what the error message would have lead me to
believe.  After a long fight I managed to rid myself of the error.  I did
the following:

1) Named my database in all lower case letters
2) Insured the Database Adminstrator was postgres
3) Insured that Connected To used template1 
3) Verified that postgres was the user that created the postgresql
installation
4) Changed the sql-ledger configuration file so that postgres was the
user.  I think pregres was the one in the configuration file.
5) Reinstalled from scratch postgresql, DBD and DBI

Unfortuantely, I don't know exactly which of these steps fixed the
problem.  I had a series of setback before I got everything up and
running.  I hope this helps you out.

	-Gary

On Fri, 23 Nov 2001, Louis B. Moore wrote:

> 
> Greetings,
> 
> I'm trying my first SQL-Ledger installation, using Postgres on a Debian
> box (Potato which implies postgres 6.5). In due course of creating the
> database I get:
> 
> ERROR: parser: parse error at or near "select" insert into tax
> (chart_id,rate) values ((select id from chart where accno = 2310),0.07);
> 
> It appears that postgres 6.5 isn't able to do the parenthetical select,
> is this problem resolved with postgres 7.x?
> 
> Thanks in advance,
> 
> Louis
> 
> 
> 
>