Re: How can I quit this: "Unique " to my table? - Mailing list pgsql-sql

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=# 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