You're right - there is an error in upgrade scripts. Database creation
scripts contain the proper constraint. I'll correct this bug in the cvs, thanks!
----- Original Message -----
From: "Klim W" <newskeeper@xxxxxxxxx>
Sent: Monday, June 13, 2005 9:58 AM
I have some problem about new sqlbill when i upgrade to prepaid,
table voipuser id and accountid is links ? ( i think is error )
-----------------
voipdb=> select * from voipaccount;
id | created | closed | disabled | balance |
balancelimit | currencysym
----+------------------------+--------+----------+---------+--------------+-------------
1 | 2005-06-10 12:36:41+07 | | f | 10.0000 | 0.0000 | USD
2 | 2005-06-10 12:37:08+07 | | f | 10.0000 | 0.0000 | USD
3 | 2005-06-10 12:37:09+07 | | f | 10.0000 | 0.0000 | USD
4 | 2005-06-10 12:37:10+07 | | f | 10.0000 | 0.0000 | USD
(4 rows)
voipdb=> select id,h323id,accountid,firstname,surname from voipuser;
id | h323id | accountid | firstname | surname
----+--------+-----------+-----------+---------
1 | voip1 | 1 | John | Smith
2 | voip2 | 1 | Joe | Smith
(2 rows)
if i add new user to use account id 4 will show error
voipdb=> INSERT INTO voipuser (h323id, accountid, chappassword,
firstname, surname) VALUES ('voip4', 4, 'secret', '4444', '4444');
ERROR: insert or update on table "voipuser" violates foreign key
constraint "voipuser_account_exists"
DETAIL: Key (accountid)=(4) is not present in table "voipuser".
i think forignkey is wrong link
it not link to table voipaccount
Best,
-------------------------------------------------------
This SF.Net email is sponsored by: NEC IT Guy Games. How far can you shotput
a projector? How fast can you ride your desk chair down the office luge track?
If you want to score the big prize, get to know the little guy.
Play to win an NEC 61" plasma display: http://www.necitguy.com/?r=20
_______________________________________________________
Posting: mailto:Openh323gk-users@xxxxxxxxxxxxxxxxxxxxx
Archive: http://sourceforge.net/mailarchive/forum.php?forum_id=8549
Unsubscribe: http://lists.sourceforge.net/lists/listinfo/openh323gk-users
Homepage: http://www.gnugk.org/
