Message-ID: <20030402011736.39194.qmail@web12702.mail.yahoo.com>
Date: Tue, 1 Apr 2003 17:17:36 -0800 (PST)
From: chester c young <chestercyoung@yahoo.com>
Subject: Re: How can I quit this:  "Unique " to my table?
To: pgsql-sql@postgresql.org
In-Reply-To: <CFA248776934FD43847E740E43C346D13796A6@ozimelb03.ozicom.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

If the constraint were named then it could be dropped - another good
reason to name all constraints.  I like Oracle Designer's way of
applying the constraints with ALTER TABLE rather than CREATE TABLE -
maintenance is much easier.

> I presume you want to remove the unique column constraint?
> 
> The ALTER TABLE command doesn't allow you to do this so another way
> is as follows:
...
> 
> If you have any reference or foreign key constraints that refer to
> the b_prestamo table, then you will need to drop those constraints
> and add them back after changing the table.
> 
> Regards,
> David Witham
> Telephony Platforms Architect
> Unidial
> 
> -----Original Message-----
> From: Luis Mix [mailto:ksql2002@yahoo.com.mx]
> Sent: Wednesday, 2 April 2003 00:35
> To: pgsql-sql@postgresql.org
> Subject: [SQL] How can I quit this: "Unique " to my table?
> 
> 
> Hello pgsql-sql,
> 
>   When my table was create I wrote this:
> 
>   MyDatabase=# create table b_prestamo(no_inventa char(16) unique not
>   null, cve_area char(10), date1 date);
>   I need now that my table can accept repeated records, but not Null.
>   How can I do that?
>   SomeBody can help me please?
>   My table has information at the moment,what can I do for maintain
>   it?
>   
>   
> 
> -- 
> Best regards,
>  Luis                          mailto:ksql2002@yahoo.com.mx
> 


__________________________________________________
Do you Yahoo!?
Yahoo! Tax Center - File online, calculators, forms, and more
http://platinum.yahoo.com