Strange problem with inserts.

On Thu, 2002-02-14 at 10:29, Manuel Duran Aguete wrote:

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".

The type field looks like a char(1) so a value to test against it should
be quoted:
SELECT * FROM data_collected where type = 'A' order by id

As you present it, your query will look for a column called "a" and
compare "type" to "a" for each row. If there is no column "a", I have
no idea what else might be wrong.

--
Oliver Elphick Oliver.Elphick@lfix.co.uk
Isle of Wight http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C

"My sheep hear my voice, and I know them, and they
follow me; And I give unto them eternal life; and they
shall never perish, neither shall any man pluck them
out of my hand." John 10:27,28