This came from pgAdmin's *Default value* field. This field is supposed to accept anything other than a string?
Aren On Fri, Jan 14, 2011 at 9:51 PM, Tom Lane <t...@sss.pgh.pa.us> wrote: > "Aren Cambre" <a...@arencambre.com> writes: > > Using pgAdmin 1.12.2, I just tried to create a table with a character > > varying(18) column. I put "none" (without the quotes) in the "Default > value" > > field for that column. > > > When I press OK to create the table, I get a dialog saying: > > An error has occurred: > > ERROR: column "none" does not exist > > Well, yeah, that's what you'll get. I don't see a bug here. > If you want the literal string 'none' as default, you should put quotes > around it. If you don't want a default, you shouldn't put anything > there. > > regards, tom lane >
