Tom Lane writes:
csaba <csaba818@xxxxxxxxxxx> writes:
Here is the CREATE script of the table which is most likely to be one
source of the error. The last error happened after an insert into this
table.
Hm, what can you say about the data that goes into the three columns
that have hash indexes? I'm going to try testing this with random data,
but it'd likely be more useful if I could reproduce your data
distribution.
A row in table Munkalap represents a job, an employee has to do.
teljesites_datum
About 2-300 rows have the same date.
statusz_pk
It's a reference to another table which describes the different states a job
can be in. There are 10 of them. Contains only numeric values. When a row is
inserted it's value is always '000000100000'. Possible values are 0 through
9 at the last digit. On a long term most rows will have '000000100004' in
this column (that is the final state.)
napi_munka_pk
Reference to a table which contains data about grouping the jobs. Contains
only numeric values. When inserting a row it is always null. Groups are
created at a later stage, then the Munkalap table is updated. About 20-30
rows have the same value if it is not null and there's always a few hundred
rows with null.
A few sample rows:
INSERT INTO munkalap VALUES ('100000003176', '000000100000', '100000003170',
NULL, '100000003171', '900000016024', NULL, 'M07I000005', '2007-03-29',
NULL, NULL, B'0', 'igen', '100000003122', 'Nagy Pistike', '723-5467', 'a',
'', '0', '2007-03-28 18:19:31.828', 4, '', NULL, NULL, NULL);
INSERT INTO munkalap VALUES ('100000003646', '000000100000', '100000003640',
NULL, '100000003641', '900000027306', NULL, 'M07I000052', '2007-04-04',
NULL, NULL, B'0', 'igen', '100000003123', 'Kis Moricka', '946-4861', 'a',
'', '0', '2007-03-28 19:07:25.546', 2, '', NULL, NULL, NULL);
INSERT INTO munkalap VALUES ('100000003761', '000000100001', '100000002783',
'100000005939', '100000003756', '900000161044', '100000007745',
'M07I000064', '2007-03-30', NULL, NULL, B'0', 'nem', '100000003122', 'Toth
Geza', '864-1135', 'a', '', '1', '2007-03-28 19:16:04.187', 2, '', NULL,
NULL, NULL);
INSERT INTO munkalap VALUES ('100000004314', '000000100001', '100000002637',
'100000005914', '100000004309', '900000097696', '100000007740',
'M07I000127', '2007-03-30', NULL, NULL, B'0', 'nem', '100000003122', 'Rizi
Rozi', '955-1919', 'a', '', '1', '2007-03-28 19:56:01', 1, '13', NULL, NULL,
NULL);
Thank you,
Csaba
