This will double as a test message since I'm not exactly sure to which email adress to send this after subscribing to the list (the reply from the listserv could say more ;)).
I finally installed freeipdb to an almost workable state.. (Btw if this email works I'll reply to Aaron about the sequence permissions - I hit that too) But one thing is bugging me right now - I can't seem to be able to get a list of free blocks.. tracked down &FreeList() and had a look at the SQL.. and now below are the results of some testing -- I seem to have an issue with these statements in regards to "= NULL" or "IS NULL" syntax.. Of course it's rather easy to patch for my needs, but anyone got an explication ? Its running under redhat linux 7/postgresql-7.2-1/apache/ipdb0.1.3[tar] freeipdb=# freeipdb=# SELECT i.ID, freeipdb-# i.BLOCK, freeipdb-# i.BITS, freeipdb-# r.name, freeipdb-# r.v6, freeipdb-# i.reclaim freeipdb-# FROM IPDB i, freeipdb-# REGIONTABLE r freeipdb-# freeipdb-# WHERE r.ID = i.REGION AND i.reclaim NOTNULL; id | block | bits | name | v6 | reclaim ----+------------+------+--------+----+--------- 1 | 1090387968 | 19 | Canada | | 1 (1 row) freeipdb=# freeipdb=# SELECT i.ID, freeipdb-# i.BLOCK, freeipdb-# i.BITS, freeipdb-# r.name, freeipdb-# r.v6, freeipdb-# i.reclaim freeipdb-# FROM IPDB i, freeipdb-# REGIONTABLE r freeipdb-# freeipdb-# WHERE r.ID = i.REGION and i.reclaim IS NULL; id | block | bits | name | v6 | reclaim ----+------------+------+--------+----+--------- 2 | 2885681152 | 8 | Canada | | 3 | 167772160 | 8 | Canada | | 4 | 3232235520 | 16 | Canada | | (3 rows) freeipdb=# freeipdb=# SELECT i.ID, freeipdb-# i.BLOCK, freeipdb-# i.BITS, freeipdb-# r.name, freeipdb-# r.v6, freeipdb-# i.reclaim freeipdb-# FROM IPDB i, freeipdb-# REGIONTABLE r freeipdb-# freeipdb-# WHERE r.ID = i.REGION and i.reclaim = NULL; id | block | bits | name | v6 | reclaim ----+-------+------+------+----+--------- (0 rows) freeipdb=# Martin Richard Sp�cialiste Technique / Technical Specialist Internet Solutions, COGNICASE
