Re: Fixing a too long column value in a before insert trigger or rule - Mailing list pgsql-general

From Tom Lane
Subject Re: Fixing a too long column value in a before insert trigger or rule
Date
Msg-id 3354.1115819064@sss.pgh.pa.us
Whole thread Raw
In response to Fixing a too long column value in a before insert trigger or rule  (Csaba Nagy <nagy@ecircle-ag.com>)
Responses Re: Fixing a too long column value in a before insert  (Csaba Nagy <nagy@ecircle-ag.com>)
List pgsql-general
Csaba Nagy <nagy@ecircle-ag.com> writes:
> We have a situation where a varchar column was limited to a too small
> maximum length in the design phase... shit happens, we will fix our db
> schema in our next database downtime or software version deployment,
> whichever comes first (we are using 7.4 and on the fly column type
> change is only from 8.0 on I guess).

Why don't you just hack the column's atttypmod?  See the archives
(and practice on a test database ;-))

            regards, tom lane

pgsql-general by date:

Previous
From: Thomas F.O'Connell
Date:
Subject: Re: SECURITY RELEASES: 7.2.8 - 7.3.10 - 7.4.8 - 8.0.3
Next
From: Tom Lane
Date:
Subject: Re: [PERFORM] "Hash index" vs. "b-tree index" (PostgreSQL