Hi,
I have a server running PostgreSQL 8.4 (Scientific Linux release 6.0).
I'm running a process which receives messages from a remote server and
logs them into a table. Here is the table structure:
CREATE TABLE messages.message_log
(
message_id text,
message_timestamp timestamp with time zon
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???
--
Scott Ribe
scott_r...@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice
--
Sent via pgsql-general mailing
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,
--
Da
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 reading does not unintentionally p
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 as a possible explanation. If
read
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 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 no
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 process is unable to insert new rows into the database
