Everything seemed to work and I have not had any problems stem from
this.
> -Original Message-
> From: Vladimir V. Zolotych [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, May 04, 2000 1:44 AM
> To: Matthew; [EMAIL PROTECTED]
> Subject: Re: [ADMIN] Removing NOT NULL Cont
When I need to change table (e.g. adding new column or changing col attr)
I used the following:
1) dump the table: pg_dump -t my_table > my_table.out
2) edit my_table slightly (e.g. remain only COPY statement)
3) delete table my_table (also my_table's sequences if any)
4) create table as it shoul
I may be missing something simple here, but I have an attribute in a
table that was created as NOT NULL. I now need to remove this
constraint. I don't see a proper way to do this. I think I can update
the pg_attribute table and change attnotnull from true to false. Is
this an acceptable soluti
