Postgres 6.51 falls down (and all backends becomes closed) on next query: > select day,(bto+proxy) as sum1,bfrom as sum2 > from traf2 > where uzer=320 > and day>='1/08/1999' > and day<'1/09/1999' > union > select NULL as day,sum(bto+proxy) as sum1,sum(bfrom) as sum2 > from traf2 > where > day>='1/08/1999' > and day<'1/09/1999' > and uzer=320 > group by uzer > order by day with such message printed by postmaster to stdout > NOTICE: Message from PostgreSQL backend: > The Postmaster has informed me that some other backend died abnormally and >possibly corrupted shared memory. > I have rolled back the current transaction and am going to terminate your >database system connection and exit. > Please reconnect to the database system and repeat your query. Definitions of table traf2: > create table traf2 > (day date not null default CURRENT_DATE, > uzer integer not null, > bto int8 not null default 0, > bfrom int8 not null default 0, > proxy int8 not null default 0, > primary key(day,uzer)); > > create index uzerday_idx on traf2 (uzer,day) Please, help Pavel Mamin, Network Programmer, SkyNet Co. ISP, Yekaterinburg, Russia ************
