>From which version were you upgrading? Were there any error messages? Did you file a bug report at bugzilla?
Postgres has changed quite a bit since those statements were created...
On Thu, 2003-01-02 at 06:14, [EMAIL PROTECTED] wrote:
> 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
>
>
> _______________________________________________
> gnucash-devel mailing list
> [EMAIL PROTECTED]
> http://www.gnucash.org/cgi-bin/mailman/listinfo/gnucash-devel
--
Matthew Vanecek
perl -e 'print $i=pack(c5,(41*2),sqrt(7056),(unpack(c,H)-2),oct(115),10);'
********************************************************************************
For 93 million miles, there is nothing between the sun and my shadow except me.
I'm always getting in the way of something...
signature_asc_DEFANGED-115102.DEFANGED-5324
Description: application/defanged-5324
