[Uml-devel] [Bug 273221] New: Invalid types in PostgreSQL codegenerator (trivial to fix).

[Nikita Skovoroda]

https://bugs.kde.org/show_bug.cgi?id=273221

           Summary: Invalid types in PostgreSQL codegenerator (trivial to
                    fix).
           Product: umbrello
           Version: unspecified
          Platform: Archlinux Packages
        OS/Version: Linux
            Status: UNCONFIRMED
          Severity: minor
          Priority: NOR
         Component: general
        AssignedTo: umbrello-devel at kde.org
        ReportedBy: chalkerx at gmail.com


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

-- 
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.