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_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 column, then it's a > bit harder. But for the table itself I believe that will work. > > regards, tom lane -- Givex - http://www.givex.com/ Derik Barclay <[EMAIL PROTECTED]>, Systems Software Engineer +1 416 350 9660 +1 416 250 9661 (fax) ---------------------------(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
