Обсуждение: ALTER DOMAIN patch ....
Hi, Does any patch to 7.3 stable exists for ALTER DOMAIN command i vaguely rember someone (mostly bruce) mentioning it in a reply. i would want to change the domain def at one place and see its effect in all the tables using it. regds mallah. -- Rajesh Kumar Mallah, Project Manager (Development) Infocom Network Limited, New Delhi phone: +91(11)6152172 (221) (L) ,9811255597 (M) Visit http://www.trade-india.com , India's Leading B2B eMarketplace.
No, ALTER DOMAIN will only be in 7.4. --------------------------------------------------------------------------- Rajesh Kumar Mallah. wrote: > > > Hi, > > Does any patch to 7.3 stable exists for ALTER DOMAIN > command i vaguely rember someone (mostly bruce) mentioning > it in a reply. > > i would want to change the domain def at one place and see > its effect in all the tables using it. > > > > regds > mallah. > > -- > Rajesh Kumar Mallah, > Project Manager (Development) > Infocom Network Limited, New Delhi > phone: +91(11)6152172 (221) (L) ,9811255597 (M) > > Visit http://www.trade-india.com , > India's Leading B2B eMarketplace. > > > > ---------------------------(end of broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org) > -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073
Bruce Momjian <pgman@candle.pha.pa.us> writes: > No, ALTER DOMAIN will only be in 7.4. And possibly not then either ;-). There are some rather serious problems with the current patch --- unless Rod can resolve them satisfactorily, I think we'll have to back out the feature. regards, tom lane
Thank you for the clarifications. I wanted to do somthing like this. say phone_no is a domain defined as varchar(25) and i want to use this domian in all DDLs. say one fine day i realize varchar(25) is not sufficient then i was planning to do something like alter domain phone_no varcahr(100) so that all DDLs would automatically get updated. Is there any other way of fullfulling this reqmt. in postgresql 7.3? Regds MAllah. On Wednesday 11 December 2002 12:44 am, Bruce Momjian wrote: > No, ALTER DOMAIN will only be in 7.4. > > --------------------------------------------------------------------------- > > Rajesh Kumar Mallah. wrote: > > Hi, > > > > Does any patch to 7.3 stable exists for ALTER DOMAIN > > command i vaguely rember someone (mostly bruce) mentioning > > it in a reply. > > > > i would want to change the domain def at one place and see > > its effect in all the tables using it. > > > > > > > > regds > > mallah. > > > > -- > > Rajesh Kumar Mallah, > > Project Manager (Development) > > Infocom Network Limited, New Delhi > > phone: +91(11)6152172 (221) (L) ,9811255597 (M) > > > > Visit http://www.trade-india.com , > > India's Leading B2B eMarketplace. > > > > > > > > ---------------------------(end of broadcast)--------------------------- > > TIP 2: you can get off all lists at once with the unregister command > > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org) -- Rajesh Kumar Mallah, Project Manager (Development) Infocom Network Limited, New Delhi phone: +91(11)6152172 (221) (L) ,9811255597 (M) Visit http://www.trade-india.com , India's Leading B2B eMarketplace.