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

Re: Adding Not Null constraints doesn't work with

From: Andreas Pflug <pgadmin(at)pse-consulting(dot)de>
To: Ben Trewern <ben_trewern(at)hotmail(dot)com>
Cc: pgadmin-support(at)postgresql(dot)org
Subject: Re: Adding Not Null constraints doesn't work with
Date: 2004-10-22 14:25:50
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgadmin-support
Ben Trewern wrote:

> ALTER TABLE operatives ALTER operative_group_id TYPE int4ALTER TABLE 
> operatives
>   ALTER COLUMN operative_group_id SET NOT NULL;

There's the semicolon and a linefeed missing.
fixed in cvs, thanks for reporting.


In response to

pgadmin-support by date

Next:From: Andreas PflugDate: 2004-10-22 14:27:18
Subject: Re: refreshing object tree
Previous:From: Richard van den BergDate: 2004-10-22 12:57:30
Subject: pgAdmin III v1.2 Beta-3 debian packages

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