drop constraint primary key

Поиск
Список
Период
Сортировка
От Marie G. Tuite
Тема drop constraint primary key
Дата
Msg-id IGELKLINGDMODABPOOFEOEKNCIAA.marie.tuite@edisonaffiliates.com
обсуждение исходный текст
Ответы Re: drop constraint primary key
Список pgsql-sql
project=# select version();                          version
-------------------------------------------------------------PostgreSQL 7.2.1 on i686-pc-linux-gnu, compiled by GCC
2.96
(1 row)

Running above, am trying to drop the primary key, but get the follwing
error.

project=# alter table class_teacher_rlt drop constraint
class_teacher_rlt_pkey restrict;
ERROR:  ALTER TABLE / DROP CONSTRAINT: class_teacher_rlt_pkey does not exist

project=# \d class_teacher_rlt                         Table "class_teacher_rlt"       Column        |           Type
       |         Modifiers
 
----------------------+--------------------------+--------------------------
--class_id             | integer                  | not nulluser_id              | integer                  | not
nullschool_id           | integer                  | not nullstart_date           | timestamp with time zone | not null
defaultnow()end_date             | timestamp with time zone |class_action_type_id | integer                  | not null
default1action_detail        | character varying(100)   |teacher_role_id      | integer
|ind_prim_teacher    | boolean                  | not null default
 
'f'::boolind_lead_teacher     | boolean                  | default 'f'status_id            | integer                  |
default1created_date         | timestamp with time zone | not null default 'now'last_modified        | timestamp with
timezone |
 
Primary key: class_teacher_rlt_pkey

Any ideas?

Thanks.

Marie




В списке pgsql-sql по дате отправления:

Предыдущее
От: Achilleus Mantzios
Дата:
Сообщение: Re: epoch to date
Следующее
От: Tom Lane
Дата:
Сообщение: Re: drop constraint primary key