Upgrade is not supported for early sqlbill versions, so the upgrade script may fail with various errors. Adding version info by hand may not help much.
Besides, for the upgrade process requires PostgreSQL version 7.4.x at least. 7.3.x is missing some features to allow upgrades.
The best way to upgrade from earlier versions is to dump data from the current
database, create a new schema from the cvs and pump the data into the new database.
----- Original Message ----- From: "Kompnet" <kompnet@xxxxxxxxx>
Sent: Sunday, October 03, 2004 11:06 AM
When I've tried to upgrade pgsqlbill from version from Aug, 26 upto last
version, I've got this message:
voipdb=> \i upgrade_tables.sql
CREATE FUNCTION
psql:upgrade_tables.sql:288: WARNING: Upgrade is supported only for database
version 1.0.1 or newer
upgrade_result
----------------
Failure
Then I've created table voipglobals and voipglobals_trig: \i c_voipglobals.sql \i c_voipglobals_trig.sql insert into voipglobals (majorversion, minorversion, buildnumber) values (1,0,1);
And after attempt to upgrade tables I've got this message:
voipdb=>\i upgrade_tables.sql
CREATE FUNCTION
psql:upgrade_tables.sql:288: INFO: Upgrading database version from 1.0.1 to
1.0.3...
...................
CONTEXT: PL/pgSQL function "upgrade_db" line 185 at SQL statement
psql:upgrade_tables.sql:288: INFO: Upgrade complete
psql:upgrade_tables.sql:288: ERROR: could not find trigger 798554
voipdb=>
Is this error a critical error? Can I proceed with "COMMIT;"? If no, how can we do the upgrade from August version?
------------------------------------------------------- This SF.net email is sponsored by: IT Product Guide on ITManagersJournal Use IT products in your business? Tell us what you think of them. Give us Your Opinions, Get Free ThinkGeek Gift Certificates! Click to find out more http://productguide.itmanagersjournal.com/guidepromo.tmpl
_______________________________________________________
List: Openh323gk-users@xxxxxxxxxxxxxxxxxxxxx Archive: http://sourceforge.net/mailarchive/forum.php?forum_id=8549 Homepage: http://www.gnugk.org/
