PostgreSQL 7.0 beta 4: Error in Insert/Select - Mailing list pgsql-bugs

From Michael Shepelev
Subject PostgreSQL 7.0 beta 4: Error in Insert/Select
Date
Msg-id 70CB60CD235DD2119AC6008048E912161C9E@VENUS
Whole thread Raw
Responses Re: PostgreSQL 7.0 beta 4: Error in Insert/Select  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: PostgreSQL 7.0 beta 4: Error in Insert/Select  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: PostgreSQL 7.0 beta 4: Error in Insert/Select  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-bugs
============================================================================
                        POSTGRESQL BUG REPORT TEMPLATE
============================================================================
Your name               : Michael Shepelev
Your email address      : docent@alias.ru


System Configuration
---------------------
  Architecture (example: Intel Pentium)         : Intel Celeron 400

  Operating System (example: Linux 2.0.26 ELF)  : Mandrake 7.0 RE

  PostgreSQL version (example: PostgreSQL-6.5.1):   PostgreSQL-7.0 beta 4

  Compiler used (example:  gcc 2.8.0)           : gcc version 2.95.2
19991024 (release)


Please enter a FULL description of your problem:
------------------------------------------------
Sorry my english.
I found bug (IMHO) in Insert/Select Union command.
Result of SELECT UNION differs from INSERT SELECT UNION.


Please describe a way to repeat the problem.   Please try to provide a
concise reproducible example, if at all possible:
----------------------------------------------------------------------
I attach an example that demonstrates this bug.



If you know how this problem might be fixed, list the solution below:
---------------------------------------------------------------------
 <<bug_in_insert.tgz>>

Attachment

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: initdb crash after install
Next
From: Tom Lane
Date:
Subject: Re: PostgreSQL 7.0 beta 4: Error in Insert/Select