This might be helpful..
--- Begin Message ---
> Can someone clue me in as to proper syntax for adding a not null
> check constraint? I've fumbled around a bit without much luck
> and I don't see this covered in the alter table section of the
> interactive docs.
>
> My pseudo code is:
> ALTER T
David Stanaway <[EMAIL PROTECTED]> wrote:
> In this case the row is ID (Case sensitive) so whenever
> you refer to it you must refer to it as "ID"
> ...
>
> > proba=# alter table tabla1 drop constraint ID not null;
>
> Here you refer to it as ID which is case folded to id and
> does not refer
On Tue, 2002-05-14 at 11:24, MG wrote:
>
> On 03-May-2002 Nick Fankhauser wrote:
> > alter table drop constraint ID unique;
> > alter table drop constraint ID not null;
> >
> > alter table add constraint ID references table2 ;
> >
>
> Hi!
>
> It not works. :(
> I try it:
> proba=# create t
On 03-May-2002 Nick Fankhauser wrote:
> alter table drop constraint ID unique;
> alter table drop constraint ID not null;
>
> alter table add constraint ID references table2 ;
>
Hi!
It not works. :(
I try it:
proba=# create table "tabla1" ("ID" int8 NOT NULL UNIQUE, "nev" varchar(20) );
NO
On 03-May-2002 Nick Fankhauser wrote:
> alter table drop constraint ID unique;
> alter table drop constraint ID not null;
>
> alter table add constraint ID references table2 ;
>
Hi!
It not works... :(
How can I change the properties of a field?
Bye!
-
Linux RedHat 7.1
/www.ontko.com/
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of MG
> Sent: Thursday, May 02, 2002 3:28 PM
> To: PostgreSQL List
> Subject: [ADMIN] ALTER TABLE for field modify...
>
>
>
> Hi!
>
> How can I modify a
Hi!
How can I modify a field of table with ALTER TABLE? I want to modify the
constraint. The TABLE is now:
"ID"int8NOT NULL, UNIQUE
But I want this:
"ID" int8 REFERENCE "table2"
THanx!
Bye!
-
Linux RedHat 7.1
-
---(end of