Error Report - SQL back end

[Matthew Vanecek]

--=-jVzqiMYfdevExovOKlt/
Content-Type: text/plain
Content-Transfer-Encoding: quoted-printable

>From which version were you upgrading?  Were there any error messages?=20
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, gnucash@cbbrowne.com wrote:
> I encountered difficulties with the recent upgrade of GnuCash=20
> (1.7.6+cvs.2002.12.31-1) relating to the SQL back end.
>=20
> There are a number of the ALTER TABLE queries that do not work with Postg=
reSQL=20
> 7.3.
>=20
> The problem is fairly simple, namely that you can't add a column and decl=
are a=20
> default in the same statement.
>=20
> Rather than
> ALTER TABLE gncEntry ADD COLUMN iguid INT4 DEFAULT 0;
>=20
> The needful queries are:
> ALTER TABLE gncEntry ADD COLUMN iguid INT4;
> ALTER TABLE gncEntry ALTER COLUMN iguid set DEFAULT 0;
>=20
> There are several such tables, and there seems to be more to it than that=
.=20=20
> But that's certainly a start :-).
> --
> output =3D 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
>=20
>=20
> _______________________________________________
> gnucash-devel mailing list
> gnucash-devel@lists.gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-devel
--=20
Matthew Vanecek
perl -e 'print $i=3Dpack(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...

--=-jVzqiMYfdevExovOKlt/
Content-Type: application/DEFANGED-115102; name="signature_asc.DEFANGED-115102"

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.6 (GNU/Linux)
Comment: For info see http://www.gnupg.org

iD8DBQA+FMHHi/CNzDSN0RIRAi1pAJ4xPIX0pllYbrC4HsNkTG7b3SHcdgCdEFub
NGiq2whsHBpzN1D3HHor6pI=
=8OaW
-----END PGP SIGNATURE-----

--=-jVzqiMYfdevExovOKlt/--