repeated warnings with 9.3 Beta 1 on windows

Started by Marc Maminover 12 years ago4 messages
#1Marc Mamin
M.Mamin@intershop.de

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

#2Amit Kapila
amit.kapila@huawei.com
In reply to: Marc Mamin (#1)
Re: 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.

--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

#3Tom Lane
tgl@sss.pgh.pa.us
In reply to: Marc Mamin (#1)
Re: 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

--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

#4Marc Mamin
M.Mamin@intershop.de
In reply to: Tom Lane (#3)
Re: repeated warnings with 9.3 Beta 1 on windows

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

--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers