Network object error

["Delaney, Mark" <MDelaney@colt-telecom.com>]

Hi,
I've just installed NorthStar 1.4 for the first time, I have setup various
Owners, Devices and Locations without too many problems.  However when I try
to add a network I get the following SQL error message :-

add_network: INSERT INTO networks
(name,parent,templateid,viewid,descr,label,network,masklen,owner,device,assi
gnuser,updateuser) VALUES('Colt UK PI Space','0','4','1','Colt PI
Space','195.110.64.0/19','+3278782464','19','1','4','0','0');
: : ERROR: referential integrity violation - key referenced from networks
not found in networks

I have tried running the SQL directly in PSQL :-

northstar=> INSERT INTO networks
(name,parent,templateid,viewid,descr,label,network,masklen,owner,device,assi
gnuser,updateuser) VALUES('Colt UK PI Space','0','4','1','Colt PI
Space','195.110.64.0/19','+3278782464','19','1','4','0','0');
ERROR:  <unnamed> referential integrity violation - key referenced from
networks not found in networks


During installation the SQL:  


northstar=> INSERT INTO networks VALUES('0','0','4','Default
Network','Default Network','0.0.0.0/0','0','0','0','0','0','now','0','now');
ERROR:  pg_atoi: error in "Default Network": can't parse "Default Network"

wasn't liked either!

Is this is known problem with 1.4, does anyone know the quick database fix?
Is there any documentation on how the database should be laid out?


regards, Mark....

-- 
Mark Delaney, COLT Telecommunications, IP Network Engineer
mdelaney@colt-telecom.com, Tel: +44 207 947 1654, Mob: +44 7812 366127

we make business straight.forward



*************************************************************************************
COLT Telecommunications
Registered in England No. 2452736
Registered Office: Bishopsgate Court, 4 Norton Folgate, London E1 6DQ
Tel. 020 7390 3900

This message is subject to and does not create or vary any contractual
relationship between COLT Telecommunications, its subsidiaries or 
affiliates ("COLT") and you. Internet communications are not secure
and therefore COLT does not accept legal responsibility for the
contents of this message.  Any view or opinions expressed are those of
the author. The message is intended for the addressee only and its
contents and any attached files are strictly confidential. If you have
received it in error, please telephone the number above. Thank you.
*************************************************************************************