Re: [PATCH] PostgreSQL DLR speedup

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