Error Report - SQL back end

[cbbrowne@acm.org]

I encountered difficulties with the recent upgrade of GnuCash 
(1.7.6+cvs.2002.12.31-1) relating to the SQL back end.

There are a number of the ALTER TABLE queries that do not work with PostgreSQL 
7.3.

The problem is fairly simple, namely that you can't add a column and declare a 
default in the same statement.

Rather than
ALTER TABLE gncEntry ADD COLUMN iguid INT4 DEFAULT 0;

The needful queries are:
ALTER TABLE gncEntry ADD COLUMN iguid INT4;
ALTER TABLE gncEntry ALTER COLUMN iguid set DEFAULT 0;

There are several such tables, and there seems to be more to it than that.  
But that's certainly a start :-).
--
output = reverse("gro.gultn@" "enworbbc")
http://cbbrowne.com/info/sap.html
"If you reinvent  the square wheel, you will  not benefit when someone
else rounds off the corners."  -- Henry Spencer