pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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.




view thread (3+ messages)  latest in thread

Message-ID: <3B43591F.5AEEBDB5@cgi.ca>
Permalink:  ../3B43591F.5AEEBDB5@cgi.ca/
Also on:    postgresql.org/message-id/3B43591F.5AEEBDB5@cgi.ca

 · 

reply

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