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
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 |