Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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! :))


pgadmin-hackers by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group