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'
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;
ERROR: parser: parse error at or near "not"
-------------------------------------------
What is the problem?
Bye!
-----------------
Linux RedHat 7.1
-----------------
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
