diff options
| author | ivan <ivan> | 2004-03-12 05:58:47 +0000 |
|---|---|---|
| committer | ivan <ivan> | 2004-03-12 05:58:47 +0000 |
| commit | 0718d6c7bc61075243d2f44f0df30fe6431f0f72 (patch) | |
| tree | c5cfa6fbaf9728da5e1e594b275adbde238661c1 /httemplate/docs/upgrade10.html | |
| parent | 01ef1d6aa064759bac796f04d999dfdf2ae3f484 (diff) | |
document trouble schema changes backported to 1.4.2
Diffstat (limited to 'httemplate/docs/upgrade10.html')
| -rw-r--r-- | httemplate/docs/upgrade10.html | 2 |
1 files changed, 1 insertions, 1 deletions
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 |