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 по дате отправления:

Предыдущее
От: Godshall Michael
Дата:
Сообщение: Re: Bug in pgadmin III displaying/exporting dat
Следующее
От: Justin Honold
Дата:
Сообщение: not sure if you take non-list posts or not