"[EMAIL PROTECTED]" <[EMAIL PROTECTED]> writes:
Today after changing (with pgadmin III) the datatype of
qrydorders.docomment from varchar(255) to varchar(2500) i got the
error "variable not found in subplan target lists" [ from a view
dependent on the table ]
This is an unsupported operation. You should perhaps complain to the
pgadmin guys that they are not correctly updating the system catalogs.
UPDATE pg_attribute SET atttypmod=2504 WHERE attrelid=25574::oid AND attnum=2;
This is what pgAdmin3 will generate to change a varchar to 2500 bytes. Please let me know what's wrong with that.
Regards, Andreas
---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
