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

Re: default value in varchar column in 1.3.82-dev

From: "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>
To: "Poul L(dot) Christiansen" <poulc(at)cs(dot)auc(dot)dk>,<pgadmin-hackers(at)postgresql(dot)org>
Subject: Re: default value in varchar column in 1.3.82-dev
Date: 2002-10-02 11:29:08
Message-ID: 03AF4E498C591348A42FC93DEA9661B868AE@mail.vale-housing.co.uk (view raw or flat)
Thread:
Lists: pgadmin-hackers
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

Responses

pgadmin-hackers by date

Next:From: Dave PageDate: 2002-10-02 11:53:19
Subject: Re: default value in varchar column in 1.3.82-dev
Previous:From: Poul L. ChristiansenDate: 2002-10-02 10:35:20
Subject: default value in varchar column in 1.3.82-dev

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