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 по дате отправления: