Ilya Anfimov schrieb am 23.11.2021 um 09:31: >> but: >> >> sisis=# select * from titel_worte where desk = '2' and feldnr = 257; >> desknr | feldnr | desk | deskorg | gesanz | aufanz | katkey1 | katkey2 >> --------+--------+------+---------+--------+--------+---------+--------- >> (0 row) >> >> sisis=# select desk, feldnr, deskorg from titel_worte where desk = '2' and feldnr = 257; >> desk | feldnr | deskorg >> ------+--------+--------- >> (0 row) >> >> The table was created as: >> >> create table titel_worte ( >> desknr serial , >> feldnr SMALLINT , >> desk VARCHAR (245) , >> deskorg VARCHAR (245) , >> gesanz INTEGER , >> aufanz INTEGER , >> katkey1 INTEGER , >> katkey2 INTEGER >> ) >> ; >> >> There are no messages in the serverlog when the SELECT fails to show the >> row. >> >> What could be the reason for this? Thanks > > Broken index could. Then this anomaly shoud have gone after reindex table. Ilya refers to the problems decribed here: https://wiki.postgresql.org/wiki/Locale_data_changes
