drop constraint primary key

From: "Marie G(dot) Tuite" <marie(dot)tuite(at)edisonaffiliates(dot)com>
To: "Pgsql-Sql(at)Postgresql(dot) Org" <pgsql-sql(at)postgresql(dot)org>
Subject: drop constraint primary key
Date: 2002-10-03 16:06:14
Message-ID: IGELKLINGDMODABPOOFEOEKNCIAA.marie.tuite@edisonaffiliates.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 null
user_id | integer | not null
school_id | integer | not null
start_date | timestamp with time zone | not null default now()
end_date | timestamp with time zone |
class_action_type_id | integer | not null default 1
action_detail | character varying(100) |
teacher_role_id | integer |
ind_prim_teacher | boolean | not null default
'f'::bool
ind_lead_teacher | boolean | default 'f'
status_id | integer | default 1
created_date | timestamp with time zone | not null default 'now'
last_modified | timestamp with time zone |
Primary key: class_teacher_rlt_pkey

Any ideas?

Thanks.

Marie

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Shridhar Daithankar 2002-10-03 16:07:55 Re: Large databases, performance
Previous Message Robert Treat 2002-10-03 15:57:29 Re: Large databases, performance