the LIMIT 1 is really only needed for EMI.
So for SMPP this could be skipped.
On 15.11.2006, at 10:49, Ben Suffolk wrote:
postgres does support LIMIT 1 in version 8.
Yes it does, but people are still running 7 in some production
environments (it just so happens the one I'm currently running
kannel on is one), so we need to make sure it works on 7.
If there is no other way around this issue with DLRs via some
protocols not having any unique identifier I guess we need to live
with the sub select. And let people who don't use the protocol use
the patch.
Or we could have a pgsql and a pgsql8 dlr handling option, so 8 can
use the limit 1. That might be a better way.
Regards
Ben
