From ae344ea5a2b4346d911d5af7cbc3ba4c54f08270 Mon Sep 17 00:00:00 2001 From: ivan Date: Thu, 23 Dec 2004 08:32:03 +0000 Subject: allow NULL zip in some countries --- httemplate/docs/upgrade10.html | 3 +++ 1 file changed, 3 insertions(+) (limited to 'httemplate/docs') 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 -- cgit v1.2.1