From: Marie G. Tuite <marie.tuite@edisonaffiliates.com>
To: Pgsql-Sql@Postgresql. Org <pgsql-sql@postgresql.org>
Subject: drop constraint primary key
Date: Thu, 3 Oct 2002 11:06:14 -0500
Message-ID: <IGELKLINGDMODABPOOFEOEKNCIAA.marie.tuite@edisonaffiliates.com> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: marie.tuite@edisonaffiliates.com
Subject: Re: drop constraint primary key
In-Reply-To: <IGELKLINGDMODABPOOFEOEKNCIAA.marie.tuite@edisonaffiliates.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox