Re: 'Following' the Primary key

From: Jean-Paul ARGUDO <jean-paul(dot)argudo(at)idealx(dot)com>
To: Turbo Fredriksson <turbo(at)bayour(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: 'Following' the Primary key
Date: 2002-03-14 13:57:10
Message-ID: 20020314135709.GA27577@pastis
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> 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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Rod Taylor 2002-03-14 14:01:20 Re: insert statements
Previous Message Hannu Krosing 2002-03-14 13:53:57 Re: Survey results on Oracle/M$NT4 to PG72/RH72 migration