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 and should be fixed. There was no data in the table when I did this.
<hint level="discreet"> My crystal ball tells me you're not using PostgreSQL 8.0.... </hint>
I just checked adding the non-null column from the table properties, this works (for an 8.0 server).
Seems we need special 7.x handling.
Regards, Andreas
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?
http://archives.postgresql.org
