Postgres Pro
Downloads
Home   >   mailing lists

Default value for char/varchar columns is not quoted automaticaly - Mailing list pgadmin-support

From Oldrich Dlouhy
Subject Default value for char/varchar columns is not quoted automaticaly
Date
Msg-id 3F7D1168.5060606@seznam.cz
Whole thread Raw
In response to Re: Cannot create index if table name contains uppercase characters  ("Dave Page" <dpage@vale-housing.co.uk>)
List pgadmin-support
Tree view 
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 by date:

Previous
From: Godshall Michael
Date:
Subject: Re: Bug in pgadmin III displaying/exporting dat
Next
From: Justin Honold
Date:
Subject: not sure if you take non-list posts or not