Re: Bug in Postgresql implementation

I guess oid is a database own id for identifying the row. So add  a  
field oid to your database and make it autofilled with a sequencial id.

On 16.06.2008, at 22:55, Hillel wrote:

> 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
>