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:[EMAIL PROTECTED]] > Sent: 02 October 2002 11:35 > To: [EMAIL PROTECTED] > 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
