Primay Key Constraint ??

Dev Shed Forums Sponsor:

August 13th, 2002, 04:25 AM

ggnanaraj

Contributing User

Join Date: Aug 2002

Location: Chennai, India

Posts: 69

Time spent in forums: 7 m 55 sec
Reputation Power: 11

Primay Key Constraint ??

As per the document...

http://www.postgresql.org/idocs/ind...altertable.html

ALTER TABLE distributors ADD PRIMARY KEY (dist_id);

should work....but for me ....get this error ... ???

Quote:

hris=# alter table con5 add primary key (nis);
ERROR: ALTER TABLE / ADD CONSTRAINT is not implemented for that constraint type.
hris=#

August 13th, 2002, 04:49 PM

ultraslacker

Contributing User

Join Date: May 2002

Posts: 56

Time spent in forums: < 1 sec
Reputation Power: 12

I've stumbled over this too -

ALTER table distributors ADD CONSTRAINT name_of_constraint PRIMARY KEY (dist_id);

__________________
Casuistry Agnostic

August 13th, 2002, 10:38 PM

ggnanaraj

Contributing User

Join Date: Aug 2002

Location: Chennai, India

Posts: 69

Time spent in forums: 7 m 55 sec
Reputation Power: 11

Hi

Thanks for your reply...

However, the following still gives the same error... ??

Quote:

ALTER table distributors ADD CONSTRAINT name_of_constraint PRIMARY KEY (dist_id);

Should we create a primary key constraint only during CREATE TABLE...??

I'm using version 7.2.1. BTW, any method to find the version of the PostgreSQL database ??

Thanks & Regards.

August 14th, 2002, 06:59 PM

ultraslacker

Contributing User

Join Date: May 2002

Posts: 56

Time spent in forums: < 1 sec
Reputation Power: 12

Hmm.. both statements are valid. I'm at a lost as I am using 7.2.1 also.

Just for kicks, check which version you are running -

pg_config --version

August 15th, 2002, 10:54 PM

ggnanaraj

Contributing User

Join Date: Aug 2002

Location: Chennai, India

Posts: 69

Time spent in forums: 7 m 55 sec
Reputation Power: 11

Quote:

Originally posted by ultraslacker
Just for kicks, check which version you are running -

pg_config --version

Hi Boss

pg_config --version shows me ...

Quote:

PostgreSQL 7.1.3

But, I've downloaded and installed 7.2.1. Previously, we had 7.1.3 on RH Linux 7.2.

Any links/info about how to upgrade from 7.1.3 to 7.2.1 properly??

I greatly appreciate you kind help.

Thanks & Regards.

Primay Key Constraint ??

Developer Shed Advertisers and Affiliates