Bug report #15873

DB Manager: add and edit table: several issues with data types

Added by Paolo Cavallini over 7 years ago. Updated about 5 years ago.

Status:Open
Priority:Normal
Assignee:-
Category:DB Manager
Affected QGIS version:3.0.0 Regression?:No
Operating System: Easy fix?:No
Pull Request or Patch supplied:No Resolution:
Crashes QGIS or corrupts data:No Copied to github as #:23791

Description

In create table:
  • field types are limited; in particular, timestamptz is missing
  • SRID has to be entered by hand; the projection widget should be added
In edit table:
  • Table properties -> Field properties: the field `Length` appears wrong; for geom it shows `geomtype,srid`, for varchar(255) and others, adding a length will cause an error:
    ALTER TABLE "public"."buffer_union" ALTER "round" TYPE varchar(255) (24)
    length has to be entered by hand changing varchar(255) into e.g. varchar(20)

In general, the interface should be cleaned up.

History

#1 Updated by Giovanni Manghi almost 7 years ago

  • Regression? set to No
  • Easy fix? set to No

#2 Updated by Paolo Cavallini about 6 years ago

  • Description updated (diff)

Still true in QGIS 3

#3 Updated by Giovanni Manghi about 6 years ago

  • Affected QGIS version changed from master to 3.0.0

Please update the affected version.

#4 Updated by Giovanni Manghi about 5 years ago

  • Status changed from Open to Closed
  • Resolution set to end of life

#5 Updated by Giovanni Manghi about 5 years ago

  • Resolution deleted (end of life)
  • Status changed from Closed to Open

Also available in: Atom PDF