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.