diff options
Diffstat (limited to 'httemplate/docs')
| -rw-r--r-- | httemplate/docs/upgrade10.html | 3 |
1 files changed, 3 insertions, 0 deletions
diff --git a/httemplate/docs/upgrade10.html b/httemplate/docs/upgrade10.html index 9e6418bf6..d8186858f 100644 --- a/httemplate/docs/upgrade10.html +++ b/httemplate/docs/upgrade10.html @@ -261,9 +261,12 @@ ALTER TABLE svc_forward ALTER COLUMN srcsvc DROP NOT NULL; ALTER TABLE h_svc_forward ALTER COLUMN srcsvc DROP NOT NULL; ALTER TABLE svc_forward ALTER COLUMN dstsvc DROP NOT NULL; ALTER TABLE h_svc_forward ALTER COLUMN dstsvc DROP NOT NULL; +ALTER TABLE cust_main ALTER COLUMN zip DROP NOT NULL; +ALTER TABLE h_cust_main ALTER COLUMN zip 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' ) ); +UPDATE pg_attribute SET attnotnull = FALSE WHERE ( attname = 'zip' ) AND ( attrelid = ( SELECT oid FROM pg_class WHERE relname = 'cust_main' ) OR attrelid = ( SELECT oid FROM pg_class WHERE relname = 'h_cust_main' ) ); If you created your database with a version before 1.4.2, dump database, edit: - cust_main and h_cust_main: increase otaker from 8 to 32 |