Re: 'Following' the Primary key
| От | Jean-Paul ARGUDO |
|---|---|
| Тема | Re: 'Following' the Primary key |
| Дата | |
| Msg-id | 20020314135709.GA27577@pastis обсуждение исходный текст |
| Ответ на | Re: 'Following' the Primary key (Turbo Fredriksson <turbo@bayour.com>) |
| Список | 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 nullop_dpt |
charactervarying(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
В списке pgsql-hackers по дате отправления: