Re: dlr_sdb bug
Stipe Tolj <[email protected]>
| Newsgroups | gmane.comp.mobile.kannel.devel |
|---|---|
| Organization | Wapme Systems AG |
| Message-ID | <[email protected]> |
> Hi Andreas. My point is that the LIMIT clauses are not optional for > Postgres. You simply can't have them. ok, so this is a bug at least for PostgreSQL?! (I thought LIMIT would be SQL92 sompliant?? hmmm.) Ok, Rory, can you do a bug report to http://bugs.kannel.org/ so we keep track of this. > Is there a way we could do this update on a unique id rather than the > timestamp (i.e. Kannel uses a value from the db rather than provide the > key?). For large dbs this could be optimised to provide very quick > performaance. yep, that's an issue we have to do. SMS that are MO or MT should have unique IDs (even accross multiple Kannel instances). I have discussed this some time ago with Alexander in a thread. We have to enforce this. @alex: should be possible to implement the UID (unique ID) to msg->sms.id (changed into an OCTSTR) in all modules, do we?! Stipe [email protected] ------------------------------------------------------------------- Wapme Systems AG Vogelsanger Weg 80 40470 Düsseldorf Tel: +49-211-74845-0 Fax: +49-211-74845-299 E-Mail: [email protected] Internet: http://www.wapme-systems.de ------------------------------------------------------------------- wapme.net - wherever you are