Received: from postgresql.org.org (webmail.postgresql.org [216.126.85.28]) by postgresql.org (8.11.3/8.11.1) with SMTP id f6ALSla20916 for ; Tue, 10 Jul 2001 17:28:47 -0400 (EDT) (envelope-from pgsql-sql-owner@postgresql.org) Received: from news.tht.net (news.hub.org [216.126.91.242]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f64IGUa05741 for ; Wed, 4 Jul 2001 14:16:30 -0400 (EDT) (envelope-from news@news.tht.net) Received: (from news@localhost) by news.tht.net (8.11.4/8.11.4) id f64I10L04488 for pgsql-sql@postgresql.org; Wed, 4 Jul 2001 14:01:00 -0400 (EDT) (envelope-from news) Message-ID: <3B43591F.5AEEBDB5@cgi.ca> From: Stephen Bell X-Mailer: Mozilla 4.72 [en] (Win95; U) X-Accept-Language: en MIME-Version: 1.0 X-Newsgroups: comp.databases.oracle.marketplace, comp.databases.oracle.misc, mailing.database.sql-general, comp.databases.postgresql.sql Subject: Re: sql startment problem PLEASE HELP ..... References: Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Lines: 37 Date: Wed, 04 Jul 2001 13:57:51 -0400 X-Complaints-To: abuse@sympatico.ca Organization: Bell Sympatico To: pgsql-sql@postgresql.org X-Archive-Number: 200107/124 X-Sequence-Number: 3912 Hi Penny, I hope someone proves me wrong, but I don't think you can modify a constraint like that....I believe you have to drop it and recreate it. Steve penny wrote: > Hi all, > > I am using Oracle8i Enterprise Edition in window 2000 > > my problem as following > > ~~~~~~~~~~~~~~~~~~~~~ > > SQL> create table ttt > 2 ( name varchar2(100) > 3 , > 4 constraint e check (name = lower(name))); > > Table created. > > SQL> alter table ttt > 2 modify constraint e > 3 check (name = upper(name)); > check (name = upper(name)) > * > ERROR at line 3: > ORA-00933: SQL command not properly ended > > > How can I modify constraint e ???? > > thanks.