Derik Barclay <[EMAIL PROTECTED]> writes:
> On December 30, 2004 11:03 pm, Tom Lane wrote:
>> If you have any indexes or views referencing this column, then it's a
>> bit harder. But for the table itself I believe that will work.
> It is combined with another field to form an index.
> Does that m
It is combined with another field to form an index.
Does that mean a re-indexing will be required? or are there other issues?
On December 30, 2004 11:03 pm, Tom Lane wrote:
> Derik Barclay <[EMAIL PROTECTED]> writes:
> > Specificaly I am looking at executing something like this:
> > UPDATE pg_attr
Derik Barclay <[EMAIL PROTECTED]> writes:
> Specificaly I am looking at executing something like this:
> UPDATE pg_attribute SET atttypmod = 16 where attname = 'x' AND attrelid =
> (select pg_class.oid from pg_class where relname = 'mytable');
If you have any indexes or views referencing this col
Specificaly I am looking at executing something like this:
UPDATE pg_attribute SET atttypmod = 16 where attname = 'x' AND attrelid =
(select pg_class.oid from pg_class where relname = 'mytable');
On December 23, 2004 05:13 pm, Derik Barclay wrote:
> Hello Group,
>
> I've run into a bit of a prob
Hello Group,
I've run into a bit of a problem, I have a varchar(6) field that I now need to
have as a varchar(12).
I am relatively new to postgres and am unsure how best to do this. What I
would like to do is alter the meta-data directly. Change the value of
atttypmod in pg_attribute directly.
