[umbrello] [Bug 400802] New: Postgresql exports incomplete enum types

[Ralf Habacker]

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

            Bug ID: 400802
           Summary: Postgresql exports incomplete enum types
           Product: umbrello
           Version: 2.26.2 (KDE Applications 18.08.2)
          Platform: Other
                OS: All
            Status: REPORTED
          Severity: normal
          Priority: NOR
         Component: exporter
          Assignee: umbrello-devel at kde.org
          Reporter: ralf.habacker at freenet.de
  Target Milestone: ---

Created attachment 116153
  --> https://bugs.kde.org/attachment.cgi?id=116153&action=edit
test case

Exporting an entity attribute with enum type results into an incomplete sql
statement


STEPS TO REPRODUCE
1. start umbrello
2. open appended file
3. export to postgresql code (perform menu entry "code"->"code generation
wizard")
4. inspect generated sql file

OBSERVED RESULT
The export does not create the required enum type e.g. in the following
statement

  tipo_empleado ENUM_1 NOT NULL,

ENUM_1 is undefined

EXPECTED RESULT
The exporter should add the enum type e.g. 

CREATE TYPE ENUM_1 AS ENUM ('Supervisor', 'Empleado', 'Obrero', 'Menor');
CREATE TABLE empleado (
  tipo_empleado ENUM_1 NOT NULL,
);

-- 
You are receiving this mail because:
You are the assignee for the bug.