additional ALTER TABLE commands

From: Tariq Muhammad <tmuhamma(at)libertyrms(dot)com>
To: jburton(at)scw(dot)org
Cc: pgsql-admin(at)postgresql(dot)org
Subject: additional ALTER TABLE commands
Date: 2001-10-17 02:53:03
Message-ID: Pine.LNX.4.21.0110162243530.14662-100000@genesis.int.libertyrms.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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(at)libertyrms(dot)com

Browse pgsql-admin by date

  From Date Subject
Next Message Tariq Muhammad 2001-10-17 03:43:03 ALTER TABLE commands
Previous Message Bruce Momjian 2001-10-17 00:46:22 Re: Database subdirectories in V7.1.x