[GENERAL] SELECT Query on DB table preventing inserts

2011-08-30 Thread Dan Scott
I'd like to ensure that the DB stops whatever else it's doing so that the insert can occur. What is the best way of doing this? Thanks, Dan Scott http://danieljamesscott.org -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] SELECT Query on DB table preventing inserts

2011-08-31 Thread Dan Scott
On Tue, Aug 30, 2011 at 13:52, Daniel Verite wrote: >        Dan Scott wrote: > >> the insert process is unable to insert new rows into the database > > You should probably provide the error message on insert or otherwise describe > how it's not working. Normally readin

Re: [GENERAL] SELECT Query on DB table preventing inserts

2011-08-31 Thread Dan Scott
On Tue, Aug 30, 2011 at 13:21, Scott Ribe 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 a

Re: [GENERAL] SELECT Query on DB table preventing inserts

2011-10-21 Thread Dan Scott
Hi, Sorry for the late response on this. On Wed, Aug 31, 2011 at 09:40, Tomas Vondra wrote: > On 31 Srpen 2011, 1:07, Dan Scott wrote: >> On Tue, Aug 30, 2011 at 13:52, Daniel Verite >> wrote: >>>        Dan Scott wrote: >>> >>>> the insert