**>From: "Johann du Preez" <[EMAIL PROTECTED]> **>To: "Alan McNatty" <[EMAIL PROTECTED]> **>Subject: Re: Two (possible) bugs with 1.4.0 **>Date: Fri, 4 Feb 2005 07:19:31 +0200 **> **>Hi Alan, **> **>>This has been captured on a past thread on this list. The dlr storage **>>handling for postgres works for postgres >= 7.4. **> **>I am using postgres v 7.4.6 and dlr storage works but there is a problem **>when Kannel attempts to remove the entries. From my earlier posting: **> **>**>1. I use postgresql (v 7.4.6) for dlr-storage, as can be seen from my **>**>config file below. However, I get the following error when it seems that **>**>Kannel wants to delete the entries from the database: **>**> **>**>2005-02-01 07:41:08 [1628] [6] ERROR: PGSQL: DELETE FROM dlr WHERE **>**>smsc='vodacom' AND ts='01/00/213d14b8/1127828553923' LIMIT 1; **>**>2005-02-01 07:41:08 [1628] [6] ERROR: PGSQL: ERROR: syntax error at or **>**>near "LIMIT" at character 76 **>**>2005-02-01 07:41:08 [1628] [6] ERROR: PGSQL: DB update failed!
Hi Alan, As stated in my previous email: ....................... PostgreSQL only supports the 'LIMIT' parameter for 'SELECT'. Neither 'DELETE' nor 'UPDATE' supports the 'LIMIT' parameter. http://news.gmane.org/gmane.comp.mobile.kannel.devel/cutoff=20932 Therefore, it's not a problem with the version but the fact that LIMIT is used with the wrong SQL command. I've testing this with v7.3.4, v7.4.7, and v8.0.1. None of the three support the LIMIT clause in conjunction with DELETE and UPDATE. LIMIT only works with the SELECT command. See ya... d.c.
