Thread: minor bug in DEFAULT

minor bug in DEFAULT

From
Kev
Date:
Greetings,

On pgAdminIII 1.6, if you add a text column NOT NULL with a default of
a single space, it doesn't get quoted, and throws an error.

Kev



Re: minor bug in DEFAULT

From
Dave Page
Date:
Kev wrote:
> Greetings,
> 
> On pgAdminIII 1.6, if you add a text column NOT NULL with a default of
> a single space, it doesn't get quoted, and throws an error.

It intentionally doesn't quote what you add in there because it has no 
idea if it's a literal string, number, function call, expression or 
whatever.

Regards, Dave