Re: [HACKERS] Backend crashes on select ... union - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: [HACKERS] Backend crashes on select ... union
Date
Msg-id 199803072116.QAA01427@candle.pha.pa.us
Whole thread Raw
In response to Backend crashes on select ... union  (Michael Bussmann <bus@fgan.de>)
List pgsql-hackers
>
> Hi there!
>
> I played around with subselects and union and noticed that issuing strange
> statements can make the backend crash.  The problem is that other clients
> connected to the same db get disconnected as well.
>
> I issued the following statement by mistake. (x1 is a table consisting only
> of one int4 value):
> select * from x1 union select * from pg_user;
>

My fault.  I never went back to make sure all union columns have the same
types.  I will work on that.

--
Bruce Momjian                          |  830 Blythe Avenue
maillist@candle.pha.pa.us              |  Drexel Hill, Pennsylvania 19026
  +  If your life is a hard drive,     |  (610) 353-9879(w)
  +  Christ can be your backup.        |  (610) 853-3000(h)

pgsql-hackers by date:

Previous
From: fgschwindt@qnx.com
Date:
Subject: Re: your mail
Next
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] dec alpha/64bit stuff