Re: PostgreSQL 7.0 beta 4: Error in Insert/Select

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Michael Shepelev <MichaelS(at)alias(dot)ru>
Cc: "'pgsql-bugs(at)postgresql(dot)org'" <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: PostgreSQL 7.0 beta 4: Error in Insert/Select
Date: 2000-04-25 06:10:02
Message-ID: 12014.956643002@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Michael Shepelev <MichaelS(at)alias(dot)ru> writes:
> I found bug (IMHO) in Insert/Select Union command.
> Result of SELECT UNION differs from INSERT SELECT UNION.

Wow, that's bizarre. I confirm seeing the inconsistent behavior.

I think it's probably got something to do with the UNION code's
manipulations of the query targetlist, but am too tired to puzzle out
more tonight. Anyone else want to look at it?

regards, tom lane

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Servio Medina 2000-04-25 20:04:55
Previous Message Michael Shepelev 2000-04-25 04:41:02 PostgreSQL 7.0 beta 4: Error in Insert/Select