> Cool. Works fine in 7.2, but not 7.1.3 (which we're running on our
> production systems)...
> Any idea how to do this on 7.1.3?
contact=# \d t_operation
Table "t_operation"
Attribute | Type | Modifier
-----------+------------------------+----------------------------------------------------
op_id | integer | not null default
nextval('operation_id_seq'::text)
op_date | date | not null
op_dpt | character varying(50) |
op_typ | character varying(50) |
op_dsc | character varying(500) |
cnx_id | integer | not null
Index: t_operation_pkey
^^^^^
Default primary key index
contact=# \d t_operation_pkey
Index "t_operation_pkey"
Attribute | Type
-----------+---------
op_id | integer
unique btree (primary key)
^^^^^^ ^^^^^^^^^^^^^
Watch for unique indices created with CREATE UNIQUE INDEX ...
Cheers,
--
Jean-Paul ARGUDO
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
