Symptom:
Details:
" ERROR:  update or delete on table "fintinventory" violates foreign key
constraint "fintfeature_providername_fkey1" on table "fintfeature"
DETAIL:  Key (providername, fintnumber)=(BT-COMMERCIAL, 2011002008001) is still
referenced from table "fintfeature"."

BT is trying delete the extensions from 8000 to 8008 on location
"OG_00_2ND_LINE_SUPPORT" from their system when they get this error.

I found this SQL that is causing the issue ...

DELETE FROM fintinventory WHERE providername = 'BT-COMMERCIAL'     AND
resellername = 'BT-COMMERCIAL'     AND companyname  = 'LOCOG'     AND
divisionname = 'LOCOG'     AND locationname = 'OG_00_2ND_LINE_SUPPORT'     AND
location_id  = '219'     AND linetype    <> 'UNREG'     AND extension  BETWEEN
'8000' AND '8008';


So I took a closer look and found that the following SQL returns 211 lines ...

SELECT COUNT(*) FROM fintfeature WHERE providername = 'BT-COMMERCIAL' AND
locationname = 'OG_00_2ND_LINE_SUPPORT';

Prerequisites:
1.BT database
2.Attempt to delete a LOCOG location.
3.

Actual Results:  
The database throws a contraint problem.

Expected Results:  
The fints should be deleted.

Conditions:
Details:
" ERROR:  update or delete on table "fintinventory" violates foreign key
constraint "fintfeature_providername_fkey1" on table "fintfeature"
DETAIL:  Key (providername, fintnumber)=(BT-COMMERCIAL, 2011002008001) is still
referenced from table "fintfeature"."

BT is trying delete the extensions from 8000 to 8008 on location
"OG_00_2ND_LINE_SUPPORT" from their system when they get this error.

I found this SQL that is causing the issue ...

DELETE FROM fintinventory WHERE providername = 'BT-COMMERCIAL'     AND
resellername = 'BT-COMMERCIAL'     AND companyname  = 'LOCOG'     AND
divisionname = 'LOCOG'     AND locationname = 'OG_00_2ND_LINE_SUPPORT'     AND
location_id  = '219'     AND linetype    <> 'UNREG'     AND extension  BETWEEN
'8000' AND '8008';


So I took a closer look and found that the following SQL returns 211 lines ...

SELECT COUNT(*) FROM fintfeature WHERE providername = 'BT-COMMERCIAL' AND
locationname = 'OG_00_2ND_LINE_SUPPORT';

Prerequisites:
1.BT database
2.Attempt to delete a LOCOG location.
3.

Actual Results:  
The database throws a contraint problem.

Expected Results:  
The fints should be deleted.