Upgrading database pgsqlbill

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hi, Michal and Oleg.
Hi, all.
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?

-- 
Best regards,
Igor Prokhorov


-------------------------------------------------------
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/

[Index of Archives]     [SIP]     [Open H.323]     [Gnu Gatekeeper]     [Asterisk PBX]     [ISDN Cause Codes]     [Yosemite News]

  Powered by Linux