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:[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 > > ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
