On 17/09/03, Andreas Fink ([EMAIL PROTECTED]) wrote: > On Mittwoch, September 17, 2003, at 02:24 Uhr, Rory Campbell-Lange > wrote: > > Hi. I've been playing around using sdb for my dlr storage. I've got > > it working nicely for Postgresql. However I had to do some muddling > > around with the code (I've never worked with C before) after noting > > some oddities in the database calls. > > > > UPDATE and DELETE don't take "Limit" clauses, certainly not for > > Postgres.
> You can remove the LIMIT clauses, they are safety checks only to only > modify one record if for some reasons there are two found. > This should only happen if you send more than one message per second to > the same destination over the same SMSC and get the same timestamp. Hi Andreas. My point is that the LIMIT clauses are not optional for Postgres. You simply can't have them. 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. Rory -- Rory Campbell-Lange <[EMAIL PROTECTED]> <www.campbell-lange.net>
