I believe this is fixed in 7.1beta.
[ Charset KOI8-R unsupported, converting... ]
> ============================================================================
> 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, skipping... ]
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026