Re: ALTER TABLE for field modify...

From: MG <makgab(at)freemail(dot)hu>
To: Nick Fankhauser <nickf(at)ontko(dot)com>
Cc: PostgreSQL List <pgsql-admin(at)postgresql(dot)org>
Subject: Re: ALTER TABLE for field modify...
Date: 2002-05-10 15:33:56
Message-ID: XFMail.20020510173356.makgab@freemail.hu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin


On 03-May-2002 Nick Fankhauser wrote:
> alter table <tablename> drop constraint ID unique;
> alter table <tablename> drop constraint ID not null;
>
> alter table <tablename> add constraint ID references table2 ;
>

Hi!

It not works... :(
How can I change the properties of a field?

Bye!
-----------------
Linux RedHat 7.1
-----------------

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2002-05-10 15:40:01 Re: Input/output error
Previous Message Rajesh Kumar Mallah. 2002-05-10 15:12:36 Log rotation for postgresql