pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: mark.powell@eds.com
To: pgsql-sql@postgresql.org
Subject: Re: sql startment problem PLEASE HELP .....
Date: 5 Jul 2001 06:42:19 -0700
Message-ID: <178d2795.0107050542.4c49cf6d@posting.google.com> (raw)
References: <a7c8116a.0107040949.860212c@posting.google.com>
	<3B43591F.5AEEBDB5@cgi.ca>

Stephen Bell <stephen.bell@cgi.ca> wrote in message news:<3B43591F.5AEEBDB5@cgi.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 --



view thread (3+ messages)

Message-ID: <178d2795.0107050542.4c49cf6d@posting.google.com>
Permalink:  ../178d2795.0107050542.4c49cf6d@posting.google.com/
Also on:    postgresql.org/message-id/178d2795.0107050542.4c49cf6d@posting.google.com

 · 

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: mark.powell@eds.com
  Subject: Re: sql startment problem PLEASE HELP .....
  In-Reply-To: <178d2795.0107050542.4c49cf6d@posting.google.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