Re: BUG #5839: pgAdmin makes bad query for creating a table when default value specified

From: Dave Page <dpage(at)pgadmin(dot)org>
To: John R Pierce <pierce(at)hogranch(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #5839: pgAdmin makes bad query for creating a table when default value specified
Date: 2011-01-15 07:57:50
Message-ID: AANLkTikAwSw0rqoY-jZOP2CJ4L=V_UGG1MZyhhbx-R49@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Sat, Jan 15, 2011 at 4:36 AM, John R Pierce <pierce(at)hogranch(dot)com> wrote:
> On 01/14/11 8:12 PM, Aren Cambre wrote:
>>
>> This came from pgAdmin's *Default value* field. This field is supposed to
>> accept anything other than a string?
>
> default value can be any valid expression

Exactly. pgAdmin doesn't have any way to know whether what you've
entered is a plain string or an expression of some kind, so it leaves
it to you to provide the quoting in this case.

--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tim Uckun 2011-01-15 13:14:32 Problems with adding a is not null to a query.
Previous Message John R Pierce 2011-01-15 04:36:24 Re: BUG #5839: pgAdmin makes bad query for creating a table when default value specified