From: chester c young <chestercyoung@yahoo.com>
To: pgsql-sql@postgresql.org
Subject: Re: How can I quit this: "Unique " to my table?
Date: Tue, 1 Apr 2003 17:17:36 -0800 (PST)
Message-ID: <20030402011736.39194.qmail@web12702.mail.yahoo.com> (raw)
In-Reply-To: <CFA248776934FD43847E740E43C346D13796A6@ozimelb03.ozicom.com>
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
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: chestercyoung@yahoo.com
Subject: Re: How can I quit this: "Unique " to my table?
In-Reply-To: <20030402011736.39194.qmail@web12702.mail.yahoo.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