From: Stephen Bell <stephen.bell@cgi.ca>
To: pgsql-sql@postgresql.org
Subject: Re: sql startment problem PLEASE HELP .....
Date: Wed, 04 Jul 2001 13:57:51 -0400
Message-ID: <3B43591F.5AEEBDB5@cgi.ca> (raw)
References: <a7c8116a.0107040949.860212c@posting.google.com>
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.
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: stephen.bell@cgi.ca
Subject: Re: sql startment problem PLEASE HELP .....
In-Reply-To: <3B43591F.5AEEBDB5@cgi.ca>
* 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