On Sat, Jan 15, 2011 at 4:36 AM, John R Pierce <pie...@hogranch.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 -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs