Weird problem - possibly a bug.
От | Glen Eustace |
---|---|
Тема | Weird problem - possibly a bug. |
Дата | |
Msg-id | 01120919571208.01550@agree-6 обсуждение исходный текст |
Ответы |
Re: Weird problem - possibly a bug.
Re: Weird problem - possibly a bug. |
Список | pgsql-general |
I have a single row table that I use to hold various data, this table is only ever updated by my programs, none of them ever do an insert ( I set the values initially using psql. I have not had cause to look in the table until today when a client notified me of a database error occuring in one of my programs. The table had 4 rows, all with the same OID. ( It is only supposed to have 1 !!) admin=# select oid,* from control; oid | next_client | next_dialin | next_domain | next_invnum | next_rctnum | next_creditcard | open_period | rebuild_mail_config | rebuild_http_config -------+-------------+-------------+-------------+-------------+-------------+-----------------+----- --------+---------------------+--------------------- 37238 | 10285 | 1032 | 10288 | 1011804 | 2011237 | 141 | 200112 | f | f 37238 | 10285 | 1032 | 10288 | 1011804 | 2011237 | 141 | 200112 | f | f 37238 | 10285 | 1032 | 10288 | 1011804 | 2011251 | 141 | 200112 | f | f 37238 | 10285 | 1032 | 10288 | 1011804 | 2011251 | 141 | 200112 | f | f (4 rows) It would appear that on a number of occassions, something has gone wrong. I am using 7.1.3 on RH7.1 Finding these extra rows, with duplicate oids has destroyed my faith in the integrity of the rest of this and other databases. Comments appreciated. -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Glen and Rosanne Eustace, GodZone Internet Services, a division of AGRE Enterprises Ltd., P.O. Box 8020, Palmerston North, New Zealand 5301 Ph/Fax: +64 6 357 8168, Mob: +64 21 424 015
В списке pgsql-general по дате отправления: