Re: default value in varchar column in 1.3.82-dev

Hi Poul,

No, varchar defaults should not be quoted automatically, because you
might be entering:

CURRENT_USER

Or

my_func()

Both of which would fail with quotes.

Regards, Dave.

> -----Original Message-----
> From: Poul L. Christiansen [mailto:poulc(at)cs(dot)auc(dot)dk]
> Sent: 02 October 2002 11:35
> To: pgadmin-hackers(at)postgresql(dot)org
> Subject: [pgadmin-hackers] default value in varchar column in
> 1.3.82-dev
>
>
> 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! :))
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
http://www.postgresql.org/users-lounge/docs/faq.html