Strange problem with inserts.

From: Manuel Duran Aguete <manuel(dot)duran(at)quantumgap(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Strange problem with inserts.
Date: 2002-02-14 10:29:36
Message-ID: 1013682577.27015.82.camel@dt1010b.quantum.int
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jairo Tcatchenco 2002-02-14 10:55:51 In Oracle, synonym, in pgsql, ...
Previous Message Holger Marzen 2002-02-14 06:45:30 Re: pgaccess failed, used to work