Default value for char/varchar columns is not quoted automaticaly

From: Oldrich Dlouhy <oldrich(dot)dlouhy(at)seznam(dot)cz>
To: PGAdmin support forum <pgadmin-support(at)postgresql(dot)org>
Subject: Default value for char/varchar columns is not quoted automaticaly
Date: 2003-10-03 06:04:24
Message-ID: 3F7D1168.5060606@seznam.cz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgadmin-support by date

  From Date Subject
Next Message Dave Page 2003-10-03 07:09:49 Re: Reverse engineered Column definition incorrect
Previous Message Godshall Michael 2003-10-02 21:17:29 Re: Bug in pgadmin III displaying/exporting dat