default value in varchar column in 1.3.82-dev

From: "Poul L(dot) Christiansen" <poulc(at)cs(dot)auc(dot)dk>
To: pgadmin-hackers(at)postgresql(dot)org
Subject: default value in varchar column in 1.3.82-dev
Date: 2002-10-02 10:35:20
Message-ID: 3D9ACBE8.9090307@cs.auc.dk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-hackers

Hi

When I try to change the default value (after the table is created) of a
varchar column to ffffff - without quotes I get the following error:
"Run-time error '-2147467259 (80004005)'
ERROR: Attribute 'ffffff' not found.

And PgAdmin closes itself down :(

But if I quote the value 'ffffff' it works fine.

Shouldn't varchar columns automatically be quoted?

I'm using PostgreSQL 7.3 beta2

Poul L. Christiansen
Dynamic Paper

PS: having the ALTER TABLE DROP COLUMN function is great! :))

Browse pgadmin-hackers by date

  From Date Subject
Next Message Dave Page 2002-10-02 11:29:08 Re: default value in varchar column in 1.3.82-dev
Previous Message Dave Page 2002-10-01 07:07:48 Re: Can't run pgadmin