From 0718d6c7bc61075243d2f44f0df30fe6431f0f72 Mon Sep 17 00:00:00 2001 From: ivan Date: Fri, 12 Mar 2004 05:58:47 +0000 Subject: [PATCH] document trouble schema changes backported to 1.4.2 --- httemplate/docs/upgrade10.html | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/httemplate/docs/upgrade10.html b/httemplate/docs/upgrade10.html index 7a16d49a1..47399c3b1 100644 --- a/httemplate/docs/upgrade10.html +++ b/httemplate/docs/upgrade10.html @@ -186,7 +186,7 @@ ALTER TABLE h_svc_forward ALTER COLUMN dstsvc DROP NOT NULL; Or on Pg versions that don't support DROP NOT NULL (tested on 7.1 and 7.2 so far): UPDATE pg_attribute SET attnotnull = FALSE WHERE ( attname = 'srcsvc' OR attname = 'dstsvc' ) AND ( attrelid = ( SELECT oid FROM pg_class WHERE relname = 'svc_forward' ) OR attrelid = ( SELECT oid FROM pg_class WHERE relname = 'h_svc_forward' ) ); -dump database, edit: +If you created your database with a version before 1.4.2, dump database, edit: - cust_main: increase otaker from 8 to 32 - cust_main: change ss from char(11) to varchar(11) - cust_credit: increase otaker from 8 to 32 -- 2.11.0