Skip site navigation (1) Skip section navigation (2)

Add Constraint

From: "Sivagami (dot)" <sivagami(at)worlddata(dot)com>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: Add Constraint
Date: 2000-10-25 17:51:00
Message-ID: 006a01c03eac$231a0a20$43c0f4d1@worlddata.com (view raw or flat)
Thread:
Lists: pgsql-sql
Hi all,

I am a newbie to Postgresql, but I am familiar with SQL. I am trying to add a constraint to my table using the ALTER TABLE command. The command goes like this :

ALTER TABLE USER_SIGNUP ADD CONSTRAINT
P_USER_SIGNUP_USER_ID PRIMARY KEY(user_id);

But it is returning the error 
ERROR:  ALTER TABLE / ADD CONSTRAINT is not implemented 

Can anyone guide me in the right direction???

Thanks.
Shiva

Responses

pgsql-sql by date

Next:From: Roderick A. AndersonDate: 2000-10-25 19:04:24
Subject: Re: Alternate Database Locations
Previous:From: Jie LiangDate: 2000-10-25 17:44:48
Subject: How to call a shell command in rule

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group