[Nagios-db-checkins] nagios-db/database/postgres upgrade.sql,NONE,1.1 UPGRADING,NONE,1.1

[Bench <be...@us...>]

Update of /cvsroot/nagios-db/nagios-db/database/postgres
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv2639

Added Files:
	upgrade.sql UPGRADING 
Log Message:
very rudimentary help for upgrading


--- NEW FILE: UPGRADING ---
If upgrading from a previous version of Nagios-DB,
you may find the upgrade.sql script will be helpful
to run. After running it, you'll want to recreate
all the stored procs and views.


On the other hand, I haven't actually tested upgrade.sql, 
so you may find the script will cause more harm than 
good.

--- NEW FILE: upgrade.sql ---
--- Get rid of types that we no longer need, and the procs that use them

drop type hostStateSummary cascade; 
drop type hostgroupStateSummary cascade; 
drop type serviceStateSummary cascade; 
drop type serviceDescStateSummary cascade;

--- Get rid of the stored procs whose arg signature has changed 
drop function configure_host(text); 
drop function configure_service(text,text);

--- Alter the schema as needed

alter table config_params rename option to opt;