Re: [PATCH] PostgreSQL DLR speedup

Ben Suffolk <[email protected]>
Newsgroups gmane.comp.mobile.kannel.devel
Message-ID <[email protected]>
> 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
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.