Re: repeated warnings with 9.3 Beta 1 on windows

From: Amit Kapila <amit(dot)kapila(at)huawei(dot)com>
To: "'Marc Mamin'" <M(dot)Mamin(at)intershop(dot)de>, <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: repeated warnings with 9.3 Beta 1 on windows
Date: 2013-05-27 11:24:00
Message-ID: 00d601ce5acc$b0855780$11900680$@kapila@huawei.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Monday, May 27, 2013 3:07 PM Marc Mamin wrote:

> 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.

..

I have tried with latest code of PG 9.3 on Windows and I get below output
which is right:

postgres=# create table tbl as select 'a' from generate_series(1,200000);
WARNING: column "?column?" has type "unknown"
DETAIL: Proceeding with relation creation anyway.
SELECT 200000

I am not sure why the command tag at end of command (Query returned
successfully: ...) is different for you, are you doing something extra than
below steps
1. initdb
2. start server
3. connect with psql
4. run the command : create table t as select 'a' from generate_series
(1,200000);

With Regards,
Amit Kapila.

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Atri Sharma 2013-05-27 11:36:12 Re: PostgreSQL Process memory architecture
Previous Message Amit Kapila 2013-05-27 10:47:19 Re: Proposal for Allow postgresql.conf values to be changed via SQL [review]