Strange problem with inserts. - Mailing list pgsql-general

From Manuel Duran Aguete
Subject Strange problem with inserts.
Date
Msg-id 1013682577.27015.82.camel@dt1010b.quantum.int
Whole thread Raw
Responses Re: Strange problem with inserts.  (Oliver Elphick <olly@lfix.co.uk>)
List pgsql-general
Hi,

I'm usign PostgreSQL v7.1.2 under Solaris 7  + DBD::Pg for a project
degree. The project is about data adquisiction and process. In the last
days when a lot of data (10>-->20 rec/sec. is inserted the processes
that are reading gets records that not correspond with the statement
that are executing.

p.e:
 The process 'A' reads data with type = A
    SELECT * FROM data_collected where type = A order by id.

id is indexed.
Looking the logs the process 'A' process data with type 'B' or 'C' or
'D' and of course "A".

Any Idea?

                            Thanks.



pgsql-general by date:

Previous
From: David Wheeler
Date:
Subject: ANNOUNCE Bricolage-Devel 1.3.0
Next
From: virka prasetia
Date:
Subject: building odb postgreSQL