Opened 16 years ago

Closed 15 years ago

#952 closed enhancement (duplicate)

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:
Must Fix for Release: No Platform: All
Platform Version: 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 (5)

comment:1 by jef, 16 years ago

Owner: changed from nobody to jef

comment:2 by jef, 16 years ago

Milestone: Version 1.0.0 → Version 2.0.0

comment:3 by jef, 16 years ago

Type: defect → enhancement

comment:4 by mwtoews, 16 years ago

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.

comment:5 by jef, 15 years ago

Resolution: → duplicate
Status: new → closed

duplicate of #62

Note: See TracTickets for help on using tickets.