Re: Strange problem with inserts. - Mailing list pgsql-general

From Oliver Elphick
Subject Re: Strange problem with inserts.
Date
Msg-id 1014321361.13241.719.camel@linda
Whole thread Raw
In response to Strange problem with inserts.  (Manuel Duran Aguete <manuel.duran@quantumgap.com>)
List pgsql-general
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


pgsql-general by date:

Previous
From: mlq@hotmail.com (Michael)
Date:
Subject: Protection of intellectual property (Schema & SQL code)
Next
From: "Andre' Blanchard"
Date:
Subject: Follow Up: How to properly build postgresql version 7.2 on Unix Platforms?