X-Original-To: pgsql-sql@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 951D4475F1C for ; Tue, 1 Apr 2003 10:19:21 -0500 (EST) Received: from lubitsch.akademie.de (ns.akademie.de [62.165.4.3]) by postgresql.org (Postfix) with ESMTP id 611CA47592C for ; Tue, 1 Apr 2003 10:19:20 -0500 (EST) Received: from [62.165.4.177] (helo=kidman.akademie1.de) by lubitsch.akademie.de with esmtp (Exim 3.33 #2) id 190NXo-00073B-00; Tue, 01 Apr 2003 17:19:24 +0200 Content-Type: text/plain; charset="iso-8859-1" From: Ian Barwick To: Achilleus Mantzios , Luis Mix Subject: Re: How can I quit this: "Unique " to my table? Date: Tue, 1 Apr 2003 17:15:54 +0200 User-Agent: KMail/1.4.3 Cc: pgsql-sql@postgresql.org References: In-Reply-To: MIME-Version: 1.0 Message-Id: <200304011715.54301.barwick@gmx.net> Content-Transfer-Encoding: quoted-printable X-Spam-Status: No, hits=-38.9 required=5.0 tests=BAYES_01,EMAIL_ATTRIBUTION,IN_REP_TO,QUOTED_EMAIL_TEXT, REFERENCES,REPLY_WITH_QUOTES,USER_AGENT_KMAIL autolearn=ham version=2.50 X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp) X-Archive-Number: 200304/5 X-Sequence-Number: 12706 On Tuesday 01 April 2003 21:26, Achilleus Mantzios wrote: > On Tue, 1 Apr 2003, Luis Mix wrote: > > Hello pgsql-sql, > > > > When my table was create I wrote this: > > > > MyDatabase=3D# 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? > > drop index b_prestamo_no_inventa_idx; ALTER TABLE b_prestamo DROP CONSTRAINT b_prestamo_no_inventa_key ?? Ian Barwick barwick@gmx.net