Re: alter table and constraints

From: "Martin A(dot) Marques" <martin(at)math(dot)unl(dot)edu(dot)ar>
To: Peter Eisentraut <peter_e(at)gmx(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: alter table and constraints
Date: 2000-08-25 18:30:31
Message-ID: Pine.LNX.4.10.10008251527260.28169-100000@math.unl.edu.ar
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, 25 Aug 2000, Peter Eisentraut wrote:

> Martin A. Marques writes:
>
> > I don't know if this is posible, but I'm trying to add and delete
> > constrains from a table. Is this posible and why am I having so much
> > problems?
>
> Because it only works for foreign keys. If you are talking about foreign
> key contraints then you should define "problems" better.

No, it was a primary key.
Can I change the constraint of NULL in a column? And what should I do if
I want to add a primary key to a table?

"And I'm happy, because you make me feel good, about me." - Melvin Udall
-----------------------------------------------------------------
Martín Marqués email: martin(at)math(dot)unl(dot)edu(dot)ar
Santa Fe - Argentina http://math.unl.edu.ar/~martin/
Administrador de sistemas en math.unl.edu.ar
-----------------------------------------------------------------

Responses

Browse pgsql-general by date

  From Date Subject
Next Message George Robinson II 2000-08-25 18:46:47 vacuumdb failed
Previous Message Matthew Rice 2000-08-25 18:18:23 Re: Creating a DB for another user (or...) (repost attempt)