Re: [HACKERS] Backend crashes on select ... union
Bruce Momjian <maillist@candle.pha.pa.us>
From: Bruce Momjian <maillist@candle.pha.pa.us>
To: bus@fgan.de (Michael Bussmann)
Cc: pgsql-hackers@postgreSQL.org
Date: 1998-03-07T21:16:29Z
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@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)