repeated warnings with 9.3 Beta 1 on windows

From: Marc Mamin <M(dot)Mamin(at)intershop(dot)de>
To: "'pgsql-hackers(at)postgresql(dot)org'" <pgsql-hackers(at)postgresql(dot)org>
Subject: repeated warnings with 9.3 Beta 1 on windows
Date: 2013-05-27 09:37:09
Message-ID: B6F6FD62F2624C4C9916AC0175D56D880CDF63AA@jenmbs01.ad.intershop.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hello,
while playing with 9.3 Beta 1 on windows, I've found following small issue:

create table t as select 'a' from generate_series (1,200000)

the warning is returned more than once:

WARNUNG: Spalte "?column?" hat Typ "unknown"
DETAIL: Relation wird trotzdem erzeugt.
WARNUNG: Spalte "?column?" hat Typ "unknown"
DETAIL: Relation wird trotzdem erzeugt.
WARNUNG: Spalte "?column?" hat Typ "unknown"
DETAIL: Relation wird trotzdem erzeugt.
...
WARNUNG: Spalte "?column?" hat Typ "unknown"
DETAIL: Relation wird trotzdem erzeugt.
WARNUNG: Spalte "?column?" hat Typ "unknown"
DETAIL: Relation wird trotzdem erzeugt.

WARNUNG: Spalte "?column?" hat Typ "unknown"
DETAIL: Relation wird trotzdem erzeugt.

Abfrage war erfolgreich durchgeführt: 200000 Zeilen, 312 ms Ausführungszeit.

same test on 9.1 Linux:

WARNING: column "a" has type "unknown"
DETAIL: Proceeding with relation creation anyway.
Query returned successfully: 20000000 rows affected, 9266 ms execution time.

regards,

Marc Mamin

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Michael Paquier 2013-05-27 09:45:30 Re: Planning incompatibilities for Postgres 10.0
Previous Message Atri Sharma 2013-05-27 08:29:53 Re: PostgreSQL Process memory architecture