Re: [HACKERS] Backend crashes on select ... union

From: Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>
To: bus(at)fgan(dot)de (Michael Bussmann)
Cc: pgsql-hackers(at)postgreSQL(dot)org
Subject: Re: [HACKERS] Backend crashes on select ... union
Date: 1998-03-07 21:16:29
Message-ID: 199803072116.QAA01427@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)candle(dot)pha(dot)pa(dot)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)

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 1998-03-07 23:10:36 Re: [HACKERS] dec alpha/64bit stuff
Previous Message fgschwindt 1998-03-07 21:05:46 Re: your mail