Adding Not Null constraints doesn't work with beta 3

Поиск
Список
Период
Сортировка
От Ben Trewern
Тема Adding Not Null constraints doesn't work with beta 3
Дата
Msg-id BAY8-F96U2xljUvJsqG000256aa@hotmail.com
обсуждение исходный текст
Ответы Re: Adding Not Null constraints doesn't work with  (Andreas Pflug <pgadmin@pse-consulting.de>)
Список pgadmin-support
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



В списке pgadmin-support по дате отправления:

Предыдущее
От: "Dave Page"
Дата:
Сообщение: Re: [pgadmin-hackers] Just to inform sucessful compilation
Следующее
От: "yoursoft@freemail.hu"
Дата:
Сообщение: BUG