Re: ALTER TABLE for field modify...

From: MG <makgab(at)freemail(dot)hu>
To: PostgreSQL List <pgsql-admin(at)postgresql(dot)org>
Subject: Re: ALTER TABLE for field modify...
Date: 2002-05-15 06:41:43
Message-ID: freemail.20020415084143.89142@fm4.freemail.hu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

David Stanaway <david(at)stanaway(dot)net> 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 to the column named ID.
>

I tried it with "ID", but it doesn't work neither. :(
Why? What should I do?

THanx!
Bye!

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message David Stanaway 2002-05-15 06:50:31 Re: ALTER TABLE for field modify... [Fwd: Re: [SQL] CHECK
Previous Message David Stanaway 2002-05-14 20:52:29 Re: ALTER TABLE for field modify...