Virgil Frum wrote:
ERROR: adding NOT NULL columns is not implemented
HINT: Add the column, then use ALTER TABLE SET NOT NULL.
Fixed in cvs, and contained in the current 2005-10-05 snapshot.
Thanks for reporting!
Regards,
Andreas
---(end of broadcast)-
Andreas Pflug wrote:
teknokrat wrote:
Sorry, I wasn't clear. This is an empty table. After creating it, I
wanted to add some more columns. I used the properties of the table to
try adding them but this failed. I then went to the column view and
added them one at a time and that worked. This beha
sage (like Address
line of url properties from web brosers).Regards,Virgil-
Original Message - From: "Andreas Pflug" <[EMAIL PROTECTED]>To: "teknokrat" <[EMAIL PROTECTED]>Cc: <[EMAIL PROTECTED]>Sent: Tuesday, October 05, 2004 7:42 PMSubject: Re:
[pga
teknokrat wrote:
Sorry, I wasn't clear. This is an empty table. After creating it, I
wanted to add some more columns. I used the properties of the table to
try adding them but this failed. I then went to the column view and
added them one at a time and that worked. This behaviour is inconsistent
Miha Radej wrote:
hi!
afaik you cannot add a not null column to a table because (in a table
where there is already some data) the field values are null. the option
to add a not null column perhaps only works on an empty table with no
rows yet. so this behaviour is expected.
therefore you need to
hi!
afaik you cannot add a not null column to a table because (in a table
where there is already some data) the field values are null. the option
to add a not null column perhaps only works on an empty table with no
rows yet. so this behaviour is expected.
therefore you need to add a column, upd
