Feature request #5113

Notes for enhancements/bug fixes

Added by Giovanni Manghi over 11 years ago. Updated over 9 years ago.

Category:DB Manager
Pull Request or Patch supplied:No Resolution:invalid
Easy fix?:No Copied to github as #:14873


This ticket should be the replacement of #2001 and are notes to be considered when the remaining Postgis Manager features will be ported into DB Manager.

*) In a postgis layer if I add/edit a column with the "postgis manager", the attribute table is not immediately updated. This doesn't happens if the column is added trough "Properties -> Attributes".

*) If I delete a postgis column with the "postgis manager" and the I open the attributes table, the column is still there filled with "NULL" values. If I reload the layer the column is gone. Does not happen if the operation is done trough the qgis vector properties.

*) When adding/editing a column I get always an error if I try to define the length of the field. It seems that doesn't happens just with the "char" data type.

*) When creating a new column, the "can be null" checkbox is selected by default, nevertheless I suggest that with datatypes that "cannot be null" to make the checkbox not active to avoid people uncheck it.

*) When creating a new column make the selection of datatype consistent with the ones available when adding a new column in the qgis vector properties (actually they list/nomenclature of datatypes is different)

*) When adding/editing a new column of a type that is text, then if selecting the "default value" option there is a bug. The query misses the " ' " around the string and so the operation fails. Example

ALTER TABLE "public".distritos ADD teste varchar NULL DEFAULT puppa

but is should be

ALTER TABLE "public".distritos ADD teste varchar NULL DEFAULT 'puppa'

Related issues

Related to QGIS Application - Bug report #2001: Postgis Manager notes for enhancements/bug fixes Closed


#1 Updated by Giovanni Manghi almost 11 years ago

  • Project changed from 27 to QGIS Application

#2 Updated by Giovanni Manghi almost 11 years ago

  • Category set to DB Manager

#3 Updated by Giovanni Manghi almost 11 years ago

  • Assignee deleted (Giuseppe Sucameli)

#4 Updated by Giovanni Manghi over 9 years ago

  • Resolution set to invalid
  • Status changed from Open to Closed

will eventually file separate tickets.

Also available in: Atom PDF