From: | mark(dot)powell(at)eds(dot)com (Mark D Powell) |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: sql startment problem PLEASE HELP ..... |
Date: | 2001-07-05 13:42:19 |
Message-ID: | 178d2795.0107050542.4c49cf6d@posting.google.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Stephen Bell <stephen(dot)bell(at)cgi(dot)ca> wrote in message news:<3B43591F(dot)5AEEBDB5(at)cgi(dot)ca>...
> 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.
Penny, I believe Steve is correct. You can find the name of the
constraint to be dropped and recreated using the dba_constraints
dictionary view.
select constraint_name, constraint_type, search_condition, status
from sys.dba_constraints
where table_name = upper('&table_name')
/
You might need to add owner to the above if you have or allow the same
object_name under different owners.
-- Mark D Powell --
From | Date | Subject | |
---|---|---|---|
Next Message | Richard Huxton | 2001-07-05 13:47:20 | Re: ConnecDB() -- couldn't send SSL negotiation packet: |
Previous Message | Jacky Cheang | 2001-07-05 09:40:25 | automatic restore of database |