Re: ALTER TABLE for field modify...

On Tue, 2002-05-14 at 11:24, MG wrote:
>
> On 03-May-2002 Nick Fankhauser wrote:
> > alter table <tablename> drop constraint ID unique;
> > alter table <tablename> drop constraint ID not null;
> >
> > alter table <tablename> add constraint ID references table2 ;
> >
>
> Hi!
>
> It not works. :(
> I try it:
> proba=# create table "tabla1" ("ID" int8 NOT NULL UNIQUE, "nev" varchar(20) );
> NOTICE:  CREATE TABLE/UNIQUE will create implicit index 'tabla1_ID_key' for
> table 'tabla1'

In this case the row is ID (Case sensitive) so whenever you refer to it
you must refer to it as "ID"


> CREATE
> proba=# create table "tabla2" ("ID2" int8 NOT NULL UNIQUE, "nev2" varchar(20) );
> NOTICE:  CREATE TABLE/UNIQUE will create implicit index 'tabla2_ID2_key' for
> table 'tabla2'
> CREATE
>
> 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 don't know if that is your problem, but it is one problem with your
code. and it will no doubt show up in many more places.



--
David Stanaway