Hi,
We recently tried to use PostgreSQL rather than mysql and Kannel can't remove the DRL from the PostgreSQL database. When Kannel tries to delete a dlr it has found, it throws an error and tries to use the column called "oid": 2008-06-16 00:12:40 [10326] [7] DEBUG: removing DLR from database 2008-06-16 00:12:40 [10326] [7] DEBUG: sql: DELETE FROM dlr WHERE oid = (SELECT oid FROM dlr WHERE smsc='smsc1' AND ts='334517' LIMIT 1); 2008-06-16 00:12:40 [10326] [7] ERROR: PGSQL: DELETE FROM dlr WHERE oid = (SELECT oid FROM dlr WHERE smsc='smsc1' AND ts='334517' LIMIT 1); 2008-06-16 00:12:40 [10326] [7] ERROR: PGSQL: ERROR: column "oid" does not exist 2008-06-16 00:12:40 [10326] [7] ERROR: PGSQL: DB update failed! >From mysql there is no problem: 2008-06-12 07:01:04 [3561] [12] DEBUG: removing DLR from database 2008-06-12 07:01:04 [3561] [12] DEBUG: sql: DELETE FROM dlr WHERE smsc='smsc1' AND ts='288856' LIMIT 1; Any suggestions for a patch? Thanks
