[umbrello-devel] [umbrello] [Bug 350238] New: postgresql sequence export uses uncommon sequence name

[Ralf Habacker]

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

            Bug ID: 350238
           Summary: postgresql sequence export uses uncommon sequence name
           Product: umbrello
           Version: 2.16.3 (KDE Applications 15.04.3)
          Platform: Other
                OS: Linux
            Status: UNCONFIRMED
          Severity: normal
          Priority: NOR
         Component: general
          Assignee: umbrello-devel at kde.org
          Reporter: ralf.habacker at freenet.de

postgresql converts the 'serial' datatype internal into a sequence using the
name scheme <tablename>_<fieldname>_seq, which is not followed by umbrello
exporting an entity attribute with auto increment enabled.

Reproducible: Always

Steps to Reproduce:
1. start umbrello
2. create an entity 'limited_areas_towns'
2. Add an attribute 'lat_id' and set autoincrement
3. select postgresql as active language
4. export the entity


Actual Results:  
The following statements are created 
CREATE SEQUENCE limited_areas_towns_lat_id START 1 INCREMENT 1 ;
ALTER TABLE limited_areas_towns ALTER COLUMN lat_id SET NOT NULL;
ALTER TABLE limited_areas_towns ALTER COLUMN lat_id SET DEFAULT
nextval('limited_areas_towns_lat_id');


Expected Results:  
The following statements should be created (note the appended '_seq')

CREATE SEQUENCE limited_areas_towns_lat_id_seq START 1 INCREMENT 1 ;
ALTER TABLE limited_areas_towns ALTER COLUMN lat_id SET NOT NULL;
ALTER TABLE limited_areas_towns ALTER COLUMN lat_id SET DEFAULT
nextval('limited_areas_towns_lat_id_seq');

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