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... :( How can I change the properties of a field? 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