Add to TODO: o Allow ALTER TABLE to modify column lengths and change to binary compatible types
--------------------------------------------------------------------------- Tom Lane wrote: > "Christopher Kings-Lynne" <[EMAIL PROTECTED]> writes: > >> There might be other cases of legal direct change of system catalog > >> entries, e,g. varchar to text, if they all are only names for internally > >> identical data structures. Can you tell which datatypes may be legally > >> interchanged? > > > Yes, you can check if they're binary compatible from the pg_cast table.... > > But nearly all of the interesting cases require you to understand the > type's interpretation of typmod, and you can't learn that from a table. > How many cases are there where blindly looking for a binary-compatible > cast in pg_cast will really do you much good? AFAICS you'd have to set > atttypmod to -1 if you change atttypid without knowing very specifically > what you are changing from and to. > > regards, tom lane > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED] > -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(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