Bug in Postgresql implementation

"Hillel" <[email protected]>
Newsgroups gmane.comp.mobile.kannel.devel
Message-ID <!&!AAAAAAAAAAAYAAAAAAAAAAht0jWTOrFAoEs8v1HaiFjCgAAAEAAAAOEUR+/[email protected]>
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
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.