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

Re: default value in varchar column in 1.3.82-dev

From: "Poul L(dot) Christiansen" <poulc(at)cs(dot)auc(dot)dk>
To: Dave Page <dpage(at)vale-housing(dot)co(dot)uk>
Cc: pgadmin-hackers(at)postgresql(dot)org
Subject: Re: default value in varchar column in 1.3.82-dev
Date: 2002-10-02 12:35:44
Message-ID: 3D9AE820.9080404@cs.auc.dk (view raw or flat)
Thread:
Lists: pgadmin-hackers
Ok, I see.

But if I would enter an unquoted string PgAdminII shuts down.

Instead of PgAdminII shutting down, shouldn't I recieve a cute little 
message saying that I should quote my strings :)

Regards,
Poul L. Christiansen
Dynamic Paper

Dave Page wrote:

>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
>
>---------------------------(end of broadcast)---------------------------
>TIP 6: Have you searched our list archives?
>
>http://archives.postgresql.org
>  
>




In response to

pgadmin-hackers by date

Next:From: rainnylinDate: 2002-10-02 15:17:15
Subject: Re: [pgadmin-hackers] Can't run pgadmin
Previous:From: Dave PageDate: 2002-10-02 11:53:19
Subject: Re: default value in varchar column in 1.3.82-dev

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