Postgres Pro
Downloads
Home   >   mailing lists

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

From Daniel Verite
Subject Re: SELECT Query on DB table preventing inserts
Date
Msg-id 62b62177-64df-45aa-a550-26c7685825fb@mm
Whole thread Raw
In response to SELECT Query on DB table preventing inserts  (Dan Scott <danieljamesscott@gmail.com>)
Responses Re: SELECT Query on DB table preventing inserts  (Dan Scott <danieljamesscott@gmail.com>)
List pgsql-general
Tree view 
    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 reading does not unintentionally prevent
writing in a concurrent session.

Best regards,
--
Daniel
PostgreSQL-powered mail user agent and storage: http://www.manitou-mail.org

pgsql-general by date:

Previous
From: Peter Warasin
Date:
Subject: Re: duplicate key violates unique on a nextval() field
Next
From: Rodrigo Gonzalez
Date:
Subject: Re: IDLE queries taking up space