> -----Original Message-----
> From: Dalton Calford [mailto:[email protected]] 
> Sent: Jueves, 03 de Septiembre de 2015 15:27
> 
> Changing a column definition for a column defined with a 
> domain, should result in an error.
> ie
> alter table  alter type should not work for columns that use domains.
> 
> 
> 
> but the following should work (syntax to be agreed upon as I 
> have seen it used differently in different databases)
> 
> 
> alter table X alter  Y domain Z  would work (would require 
> the domain being changed to, exists)
> alter domain alter type would also work is all versions of 
> that column need to change.

Dalton, I'm not sure we're speaking about the same thing. I'm describing a
problem that happens with implicit domains that are created behind scenes by
the engine (RDB$NNN).

C.


------------------------------------------------------------------------------
Monitor Your Dynamic Infrastructure at Any Scale With Datadog!
Get real-time metrics from all of your servers, apps and tools
in one place.
SourceForge users - Click here to start your Free Trial of Datadog now!
http://pubads.g.doubleclick.net/gampad/clk?id=241902991&iu=/4140
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Reply via email to