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