> -----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?

Regards, Dave

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
      subscribe-nomail command to [EMAIL PROTECTED] so that your
      message can get through to the mailing list cleanly

Reply via email to