Bug 273221

Version:           unspecified (using Devel) 
OS:                Linux

http://websvn.kde.org/trunk/KDE/kdesdk/umbrello/umbrello/codegenerators/sql/postgresqlwriter.cpp?view=markup

72	    l.append( "time without timezone" );
73	    l.append( "time with timezone" );
74	    l.append( "timestamp without timezone" );
75	    l.append( "time with timezone" );

should be replaced by

72	    l.append( "time without time zone" );
73	    l.append( "time with time zone" );
74	    l.append( "timestamp without time zone" );
75	    l.append( "time with time zone" );

Reproducible: Always

Steps to Reproduce:
Set current language to PostgreSQL, fill datatypes with default ones, make an entity with field of type "time with timezone", export it to PostgreSQL sql file, try to load that sql to a PostgreSQL database.

Actual Results:  
PostgreSQL fails to create a table, complains about that datatype.

Expected Results:  
PostgreSQL should create a valid table.

„timezone“ has to be written as „time zone“.

http://www.postgresql.org/docs/9.0/interactive/datatype-datetime.html