Обсуждение: repeated warnings with 9.3 Beta 1 on windows

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.

Marc Mamin <M.Mamin@intershop.de> writes:
> 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:

I can't duplicate this either.

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

That doesn't look like anything psql would print, which makes me think
that you're using some other client application and it's that
application that's misbehaving.
        regards, tom lane

> which makes me think that you're using some other client application

Hello,
Tom is right ( as always :-) :

http://postgresql.1045698.n5.nabble.com/bug-repeated-messages-in-pgadmin-1-18-0-Alpha-1-query-tool-messages-pane-td5755749.html


sorry for the disturbance.
Marc Maminm
________________________________________
Von: Tom Lane [tgl@sss.pgh.pa.us]
Gesendet: Montag, 27. Mai 2013 16:25
An: Marc Mamin
Cc: 'pgsql-hackers@postgresql.org'
Betreff: Re: [HACKERS] repeated warnings with 9.3 Beta 1 on windows

Marc Mamin <M.Mamin@intershop.de> writes:
> 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:

I can't duplicate this either.

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

That doesn't look like anything psql would print, which makes me think
that you're using some other client application and it's that
application that's misbehaving.
                       regards, tom lane