Received: from makus.postgresql.org ([98.129.198.125]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1THAKG-0000wf-7Z for pgsql-admin@postgresql.org; Thu, 27 Sep 2012 09:24:08 +0000 Received: from hub.ringways.co.uk ([77.86.27.30] helo=mail.ringways.co.uk) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1THAKE-0004UZ-7r for pgsql-admin@postgresql.org; Thu, 27 Sep 2012 09:24:07 +0000 Received: from localhost ([127.0.0.1] helo=mail.ringways.co.uk) by mail.ringways.co.uk with esmtp (Exim 4.69) (envelope-from ) id 1THAK7-0005qh-IL for pgsql-admin@postgresql.org; Thu, 27 Sep 2012 10:24:01 +0100 Received: from eddie.ringways.co.uk ([10.1.1.115] helo=eddie.ringways.co.uk) by mail.ringways.co.uk with ESMTP id qANtOW4c40684; Thu, 27 Sep 2012 10:23:55 +0100 From: Gary Stainburn Organization: Ringways Garages Ltd To: pgsql-admin@postgresql.org Subject: alter table alter column to resize a varchar Date: Thu, 27 Sep 2012 10:23:57 +0100 User-Agent: KMail/1.9.10 MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <201209271023.57710.gary.stainburn@ringways.co.uk> X-SpamTest-Envelope-From: gary.stainburn@ringways.co.uk X-SpamTest-Info: Profiles 20401 [Mar 31 2011] X-SpamTest-Method: none X-SpamTest-Rate: 0 X-SpamTest-Status: Not detected X-SpamTest-Status-Extended: not_detected X-SpamTest-Version: SMTP-Filter Version 3.0.0 [0285], KAS30/SDK/Release X-Anti-Virus: Kaspersky Mail Gateway, version: 5.6.28/RELEASE, bases: 20110331T110535 #5151353, check: 20120927 clean X-Spam-Score: -51.6 (---------------------------------------------------) X-Spam-Report: Spam detection software, running on the system "ollie.ringways.co.uk", has identified this incoming email as possible spam. The original message has been attached to this so you can view it (if it isn't spam) or label similar future email. If you have any questions, see Gary Stainburn for details. Content preview: Hi folks. I'm planning on extending a field in one of my main tables using: alter table stock alter column type varchar(255); [...] Content analysis details: (-51.6 points, 15.0 required) pts rule name description ---- ---------------------- -------------------------------------------------- -50 ALL_TRUSTED Passed through trusted hosts only via SMTP -2.6 BAYES_00 BODY: Bayesian spam probability is 0 to 1% [score: 0.0000] 1.0 RING_SAFE RING_SAFE X-Pg-Spam-Score: -0.0 (/) X-Archive-Number: 201209/157 X-Sequence-Number: 40098 Hi folks. I'm planning on extending a field in one of my main tables using: alter table stock alter column type varchar(255); to extend it from the current varchar(80). My concern is that this table and this field is used in a number of views, and views of views. Are then any gotchas that I need to worry about or things I need to check, or will it just work? Gary -- Gary Stainburn Group I.T. Manager Ringways Garages http://www.ringways.co.uk