Re: Possible issue in pgAdmin regarding varchar adjustment

> -----Original Message-----
> From: Josh Berkus [mailto:josh(at)agliodbs(dot)com]
> 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?

Regards, Dave