Кто-нибудь сталкивался с такой проблемой ? Вот кусок кода
begin;
update stat_referer_rating set c=0;
select id_server,cs_parse_url_host(from_server) as referer,first_link(id_server,cs_parse_url_host(from_server)) as url,count(*) as c into temp temp_table_1 from stat_log_not_today group by id_server,referer;
select * into temp temp_table from temp_table_1 EXCEPT ALL select id_server,referer,url,c from (select * from temp_table_1 left join stat_exclude_like using(id_server) where cs_parse_url_host(referer)=like_ex) as foo;
drop table temp_table_1;
select * into temp temp_table_1 from temp_table EXCEPT ALL select id_server,referer,url,c from (select * from temp_table left join stat_exclude_server using(id_server) where lower(referer)=lower(server_name)) as foo1;
drop table temp_table;
select * into temp temp_table from temp_table_1;
drop table temp_table_1;
select * into temp temp_update from (select id_server,referer from temp_table INTERSECT ALL select id_server, referer from stat_referer_rating) as cros left join temp_table using (id_server,referer);
update stat_referer_rating set c=temp_update.c, url=temp_update.url where stat_referer_rating.id_server=temp_update.id_server and stat_referer_rating.referer=temp_update.referer;
insert into stat_referer_rating select * from (select id_server,referer from temp_table EXCEPT ALL select id_server, referer from stat_referer_rating) as diff left join temp_table using (id_server,referer);
drop table temp_table;
drop table temp_update;
update stat_referer_rating set kt=(kt+(c-kt)/".P.")::numeric, km=case when km<(kt+(c-kt)/".P.")::numeric then (kt+(c-kt)/".P.")::numeric else km end, d=((c-kt)/".P.")::numeric;
delete from stat_referer_rating where kt<1/".P."::numeric;
commit;
Возникает ошибка
ERROR: shared buffer hash table corrupted.
POSTGRESQL 7.4.11
OS FreeBSD 5.4 RELEASE i386