Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 0A89A47677B for ; Thu, 3 Oct 2002 12:04:03 -0400 (EDT) Received: from edisonaffiliates.com (w205.z208176060.chi-il.dsl.cnc.net [208.176.60.205]) by postgresql.org (Postfix) with SMTP id 1B864476A9A for ; Thu, 3 Oct 2002 12:03:50 -0400 (EDT) Received: from redhen ([12.32.94.66]) by edisonaffiliates.com ; Thu, 03 Oct 2002 10:59:05 -0500 Reply-To: From: "Marie G. Tuite" To: "Pgsql-Sql@Postgresql. Org" Subject: drop constraint primary key Date: Thu, 3 Oct 2002 11:06:14 -0500 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2911.0) X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 Importance: Normal X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200210/43 X-Sequence-Number: 9761 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