Thread: repeated warnings with 9.3 Beta 1 on windows

repeated warnings with 9.3 Beta 1 on windows

From
Marc Mamin
Date:
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
 
 

Re: repeated warnings with 9.3 Beta 1 on windows

From
Amit Kapila
Date:
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.




Re: repeated warnings with 9.3 Beta 1 on windows

From
Tom Lane
Date:
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



Re: repeated warnings with 9.3 Beta 1 on windows

From
Marc Mamin
Date:
> 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