Bug 273221 - Invalid types in PostgreSQL codegenerator (trivial to fix).
Summary: Invalid types in PostgreSQL codegenerator (trivial to fix).
Status: RESOLVED FIXED
Alias: None
Product: umbrello
Classification: Applications
Component: general (show other bugs)
Version: unspecified
Platform: Arch Linux Linux
: NOR minor
Target Milestone: ---
Assignee: Umbrello Development Group
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2011-05-13 20:27 UTC by Nikita Skovoroda
Modified: 2013-11-06 17:32 UTC (History)
1 user (show)

See Also:
Latest Commit:
Version Fixed In: 4.7.4


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Nikita Skovoroda 2011-05-13 20:27:49 UTC
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
Comment 1 Andi Fischer 2011-05-16 22:31:38 UTC
commit 1232288
Comment 2 Ralf Habacker 2013-11-06 17:32:41 UTC
set version-fixed-in from 4.7.4 changelog