Re: Strange problem with inserts.
От | Oliver Elphick |
---|---|
Тема | Re: Strange problem with inserts. |
Дата | |
Msg-id | 1014321361.13241.719.camel@linda обсуждение исходный текст |
Ответ на | Strange problem with inserts. (Manuel Duran Aguete <manuel.duran@quantumgap.com>) |
Список | 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 по дате отправления: