reliable way to crash postgres :) - Mailing list pgsql-sql

From Jens Glaser
Subject reliable way to crash postgres :)
Date
Msg-id Pine.LNX.4.05.9909140800080.356-100000@helena.jens.de
Whole thread Raw
Responses Re: [SQL] reliable way to crash postgres :)  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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 by date:

Previous
From: "Stéphane FILLON"
Date:
Subject: Permission problem with COPY FROM
Next
From: Tom Lane
Date:
Subject: Re: [SQL] reliable way to crash postgres :)