Re: Locking rows

> ordered. But while I gathering the data, which takes more than one
> query, a customer might come along and cancel an invoice.

So what?  Wouldn't you have the same situation if they cancelled
imediately after you finished the report?

Jon

>
> In that case I would print a receipt for something that was cancelled.
>
> I need to find a way to avoid this. I thought locking was a way around
> this ... or maybe I need to change my "business" logic or the way the
> app gathers the data?
>
> Jc
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
>