reliable way to crash postgres :)

Поиск
Список
Период
Сортировка
От Jens Glaser
Тема reliable way to crash postgres :)
Дата
Msg-id Pine.LNX.4.05.9909140800080.356-100000@helena.jens.de
обсуждение исходный текст
Ответы Re: [SQL] reliable way to crash postgres :)  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-sql
Hi,

I think I've found a pretty reliable way to crash my pgsql backend.

To reproduce (at least on 6.5.1.) enter:
  select * from pg_attribute where (case when 1=1 then     (attname='testname') else (0=1) end);

I chose the pg_attribute table because it exists on every system :),
while the query does not look to make too much sense I orignally
wanted to implement different WHERE conditions based on another
condition (here just 1=1 :-)

Regards,

-- 
Jens Glaser     Am Holderstrauch 13, 36041 Fulda, 0661/9429507    jens@jens.de




В списке pgsql-sql по дате отправления:

Предыдущее
От: "Stéphane FILLON"
Дата:
Сообщение: Permission problem with COPY FROM
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [SQL] reliable way to crash postgres :)