Skip site navigation (1) Skip section navigation (2)

Re: substring implementation (long string)

From: Joe Conway <mail(at)joeconway(dot)com>
To: Scott Cain <cain(at)cshl(dot)org>
Cc: pgsql General List <pgsql-general(at)postgresql(dot)org>
Subject: Re: substring implementation (long string)
Date: 2003-07-30 14:32:30
Message-ID: 3F27D6FE.2040201@joeconway.com (view raw or flat)
Thread:
Lists: pgsql-general
Scott Cain wrote:
> Thanks--that looks like exactly what I need.  Here's a related question:
> when I do the alter table, is there a way I can make it "retroactive". 
> That is, I ran the alter table, and nothing happened.  I expected the
> storage space for the database to jump, and for it to take a while to do
> it, but it did not.  So I am guessing that the alter table only applies
> to new data put in.  Is there a way to make it apply to all the data
> already in the column, short of dropping the table and reloading it. 
> Dropping and reloading is unattractive because of several foreign key
> constraints on this table.
> 

You probably could do something like:

UPDATE mytable SET somefield = somefield;

Joe


In response to

pgsql-general by date

Next:From: Elielson FontaneziDate: 2003-07-30 15:52:09
Subject: ALTER TABLE ... DROP CONSTRAINT
Previous:From: Scott CainDate: 2003-07-30 14:28:28
Subject: Re: substring implementation (long string)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group