BUG #1433: domain check constraint not checked when adding new column
| От | craig perras |
|---|---|
| Тема | BUG #1433: domain check constraint not checked when adding new column |
| Дата | |
| Msg-id | 200501220828.j0M8SOvJ006967@developer.pgadmin.org обсуждение исходный текст |
| Ответы |
Re: BUG #1433: domain check constraint not checked when adding new column
Re: BUG #1433: domain check constraint not checked when adding new column |
| Список | pgsql-bugs |
The following bug has been logged online: Bug reference: 1433 Logged by: craig perras Email address: craigp98072@yahoo.com PostgreSQL version: 8.0 release Operating system: win2000 Description: domain check constraint not checked when adding new column Details: Domain check constraint not checked when adding new column. repro: add domain 'string' of base type text with non-null constraint add column of type 'string' to table with existing rows works; all rows have new column's value set to null expected: error: cannot add column due to non-null constraint in domain 'string' notes: could not insert a new row with non-null value for 'string' column (as expected) trying to add a column of type text with non-null constraint produces expected error message
В списке pgsql-bugs по дате отправления: