Ticket #952 (closed enhancement: duplicate)

Opened 5 years ago

Last modified 4 years ago

Support PostgreSQL uuid type

Reported by: christiangda Owned by: jef
Priority: minor: annoyance Milestone: Version 2.0.0
Component: Data Provider Version: Trunk
Keywords: uuid Cc:
Platform Version: Platform: All
Must Fix for Release: No Awaiting user input: no

Description

Hi,

Recently I have been working with PostgreSQL 8.3 and uuid data type. When I have a table with uuid data type as primary key, qgis can't show or manipulate it.

Change History

Changed 5 years ago by jef

  • owner changed from nobody to jef

Changed 5 years ago by jef

  • milestone changed from Version 1.0.0 to Version 2.0.0

Changed 5 years ago by jef

  • type changed from defect to enhancement

Changed 5 years ago by mwtoews

A suggested workaround for this is to:

  1. drop the primary key constraint
  2. add a unique key constraint on the uuid column (former pkey)
  3. add a serial column (this could be on the far right-side .. doesn't matter)
  4. create a primary key on the newly created serial column

FYI, very few GIS programs allow a non-integer primary key.

Changed 4 years ago by jef

  • status changed from new to closed
  • resolution set to duplicate

duplicate of #62

Note: See TracTickets for help on using tickets.