-----Original Message-----
From: Josh Berkus [mailto:[EMAIL PROTECTED] Sent: 09 November 2004 00:47
To: Dave Page
Subject: Possible issue in pgAdmin regarding varchar adjustment
Dave,
A user on IRC claims that pgAdminIII allows changing the length of varchar fields, and executes it through updates to pg_attributes and other system tables. If this is incorrect, ignore the rest of this message.
The problem with direct updating of pg_attribute in 7.3 and 7.4 is that all indexes and views which depend on the table would have to be dropped and re-created. Also, the pg_statistic rows for that column would need to be purged and regenerated. So it seems like a misfeature.
Hi Josh,
I'm not entirely sure as I've never really worked on that part of the code. Andreas, can you comment on this?
It's correct, and it's on the TODO list as essential. It's clearly a caveat now (-> FAQ update needed)
Regards, Andreas
---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
