Postgres Pro
Downloads
Home   >   mailing lists

Re: SELECT Query on DB table preventing inserts - Mailing list pgsql-general

From Dan Scott
Subject Re: SELECT Query on DB table preventing inserts
Date
Msg-id CANQKhhmfD5S_stvFh2c2Kg2CgxWqtVsSX6BBwW==j+2zAiSihg@mail.gmail.com
Whole thread Raw
In response to Re: SELECT Query on DB table preventing inserts  (Scott Ribe <scott_ribe@elevated-dev.com>)
List pgsql-general
Tree view 
On Tue, Aug 30, 2011 at 13:21, Scott Ribe <scott_ribe@elevated-dev.com> wrote:
> On Aug 30, 2011, at 8:22 AM, Dan Scott wrote:
>
>> Perhaps because I'm locking the table with my query?
>
> Do you mean you're explicitly locking the table? If so, why???

No, not explicitly. I just thought of it as a possible explanation. If
reading from the table does not lock the table for writing, then
that's not the problem.

Thanks,

Dan

>
> --
> Scott Ribe
> scott_ribe@elevated-dev.com
> http://www.elevated-dev.com/
> (303) 722-0567 voice
>
>
>
>
>

pgsql-general by date:

Previous
From: Dan Scott
Date:
Subject: Re: SELECT Query on DB table preventing inserts
Next
From: "Tomas Vondra"
Date:
Subject: Re: SELECT Query on DB table preventing inserts