Skip site navigation (1) Skip section navigation (2)

PostgreSQL 7.0 beta 4: Error in Insert/Select

From: Michael Shepelev <MichaelS(at)alias(dot)ru>
To: "'pgsql-bugs(at)postgresql(dot)org'" <pgsql-bugs(at)postgresql(dot)org>
Subject: PostgreSQL 7.0 beta 4: Error in Insert/Select
Date: 2000-04-25 04:41:02
Message-ID: 70CB60CD235DD2119AC6008048E912161C9E@VENUS (view raw or flat)
Thread:
Lists: pgsql-bugs
============================================================================
                        POSTGRESQL BUG REPORT TEMPLATE
============================================================================
Your name               : Michael Shepelev
Your email address      : docent(at)alias(dot)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: bug_in_insert.tgz
Description: application/octet-stream (2.0 KB)

Responses

pgsql-bugs by date

Next:From: Tom LaneDate: 2000-04-25 06:10:02
Subject: Re: PostgreSQL 7.0 beta 4: Error in Insert/Select
Previous:From: Tom LaneDate: 2000-04-25 03:42:46
Subject: Re: initdb crash after install

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group