--- jack <[EMAIL PROTECTED]> wrote:
> Hi, all
> I'm using postgreSQL 7.2.3. The following statement
> always cuases a parser
> error, "parse error at or near NOT". Please adivse,
> thank you in advance.
>
> ALTER TABLE _acct_group1
> ALTER groupkey SET NOT NULL;
I believe you will need to u
his syntax is valid in 7.3 (not 7.2)
>
> - Original Message -
> From: "Tomasz Myrta" <[EMAIL PROTECTED]>
> To: "jack" <[EMAIL PROTECTED]>
> Cc: <[EMAIL PROTECTED]>
> Sent: Tuesday, January 07, 2003 11:31 PM
> Subject: Re: [S
jack wrote:
But on postgreSQL 7.2 reference manual, there is a statement for alter
table
such as, ALTER TABLE [ ONLY ] table [ * ]
ALTER [ COLUMN ] column { SET | DROP } NOT NULL
Do you mean this one hasn't been implemented?
Jack
Strange. I don't have such ALTER TABLE in my 7.2 documenta
AIL PROTECTED]>
To: "jack" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Tuesday, January 07, 2003 11:31 PM
Subject: Re: [SQL] A problem about alter table
> jack wrote:
>
> > Hi, all
> > I'm using postgreSQL 7.2.3. The following statement alwa
jack wrote:
Hi, all
I'm using postgreSQL 7.2.3. The following statement always cuases a parser
error, "parse error at or near NOT". Please adivse, thank you in advance.
ALTER TABLE _acct_group1
ALTER groupkey SET NOT NULL;
Jack
From Postgres 7.2 documentation:
"In the current implementa
Hi, all
I'm using postgreSQL 7.2.3. The following statement always cuases a parser
error, "parse error at or near NOT". Please adivse, thank you in advance.
ALTER TABLE _acct_group1
ALTER groupkey SET NOT NULL;
Jack
---(end of broadcast)---
T
