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

Reply via email to