Default value for char/varchar columns is not quoted automaticaly
| От | Oldrich Dlouhy |
|---|---|
| Тема | Default value for char/varchar columns is not quoted automaticaly |
| Дата | |
| Msg-id | 3F7D1168.5060606@seznam.cz обсуждение |
| Ответ на | Re: Cannot create index if table name contains uppercase characters ("Dave Page" <dpage@vale-housing.co.uk>) |
| Список | pgadmin-support |
Default value for char/varchar columns is not quoted automaticaly when creating a table or adding new column to existing table. -- PGAdmin -- version: PGAdmin III version 1.0.0 OS: Windows XP Professional SP1 -- postgres -- Postgres: 7.3.4 on i686-pc-linux-gnu OS: RedHat Linux 9 - Steps to reproduce -- 1.Add a new column of (var)char type to existing table with column's default value "test value" (withou the quotes) -- Current result -- Column is not added (parse error) -- Expected result -- New column is added -- Notes -- Same behavior is when creating the table. If this behavior is "by design" and the user required to enter the quotes manualy, take it please just as a feature request to automaticaly quote character-type defaults Thank you for creating great tool as PGAdmin is. Hope this will help you to improve PGAdmin. Oldrich Dlouhy
В списке pgadmin-support по дате отправления: