Re: SELECT Query on DB table preventing inserts

From: Dan Scott <danieljamesscott(at)gmail(dot)com>
To: Scott Ribe <scott_ribe(at)elevated-dev(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: SELECT Query on DB table preventing inserts
Date: 2011-08-30 22:45:44
Message-ID: CANQKhhmfD5S_stvFh2c2Kg2CgxWqtVsSX6BBwW==j+2zAiSihg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Aug 30, 2011 at 13:21, Scott Ribe <scott_ribe(at)elevated-dev(dot)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(at)elevated-dev(dot)com
> http://www.elevated-dev.com/
> (303) 722-0567 voice
>
>
>
>
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Dan Scott 2011-08-30 23:07:28 Re: SELECT Query on DB table preventing inserts
Previous Message Merlin Moncure 2011-08-30 22:31:08 Re: heavy swapping, not sure why