Home > mailing lists

ALTER TABLE commands - Mailing list pgsql-admin

From	Tariq Muhammad
Subject	ALTER TABLE commands
Date	October 17, 2001 03:07:38
Msg-id	Pine.LNX.4.21.0110162342190.16438-100000@genesis.int.libertyrms.com Whole thread Raw
Responses	Re: ALTER TABLE commands (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
List	pgsql-admin

Tree view


Hello

I am trying to set value of an attribute to not null but it does not work
I am using the following statment:

UPDATE contact
SET attnotnull = TRUE
WHERE attname = '_rserv_ts' ;

The error I get is as under :

ERROR:  Attribute 'attname' not found


I am running postgressql version is 7.1.3 under solaris.

Your help would be much appreciated.

Thanks

Tariq Muhammad
L i b e r t y   R M S
http://www.libertyrms.com
tmuhamma@libertyrms.com

pgsql-admin by date:

From: Bruce Momjian
Date: 17 October 2001, 01:22:30
Subject: Re: Database subdirectories in V7.1.x

From: Tariq Muhammad
Date: 17 October 2001, 03:11:23
Subject: additional ALTER TABLE commands

ALTER TABLE commands - Mailing list pgsql-admin

Previous

Next