All,
There seems to be a new problem with beta 3.
When you try to add a Not Null constraint, the SQL made is incorrect.
When trying to change the operative_group_id field in the operatives table I get:
ALTER TABLE operatives ALTER operative_group_id TYPE int4ALTER TABLE operatives
ALTER COLUMN operative_group_id SET NOT NULL;
This I'm sure used to work previously,
I'm using PostgreSQL 8.0 beta2
Regards,
Ben
_________________________________________________________________ Express yourself with cool new emoticons http://www.msn.co.uk/specials/myemo
---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
