Re : Are domains supported ?

[Laurent ROCHE <la...@yahoo.com>]

Hi,

Thanks for pointing me to the opened issue (as said before I am not familiar with this site ... yet).

I understand that domains are really difficult to be fully supported as there is no real standard ont his (on some rDBMS they're called user datatypes).

But I would think a first easy step, would be to "translate" the domain into its equivalent into the XML file.
This way an export - import can be done : the imported database would not have any domains (or user datatypes or whatever it's called) but at least it will be possible to create it and to do some work when a domain has been defined.

Right now, I can not use DDL-Utils for my database ... and that's a shame !

 
Have fun,
L@u
The Travelling Froggy
TravellingFroggy.info

----- Message d'origine ----
De : Thomas Dudziak <to...@gmail.com>
À : ddlutils-user@db.apache.org
Envoyé le : Mercredi, 15 Novembre 2006, 22h34mn 29s
Objet : Re: Are domains supported ?

On 11/15/06, Laurent ROCHE <la...@yahoo.com> wrote:

> I am moving a PostgreSQL database to a Derby database, and I have troubles with domains defined in Posgres.
> It seems there are not supported as in the xml file generated (using the ant tasks), the type is always OTHER !
>
> Am I missing something ?
> Are there any plans to support this, soon ?

There is an open issue for this
(http://issues.apache.org/jira/browse/DDLUTILS-84) but it is not
currently targeted for a release. Domains are problematic in that they
are not supported by all databases, and providing an alternative
implementation so that you can use them in your XML regardless of
whether the db has native support, is tricky.

cheers,
Tom





	
	
		
___________________________________________________________________________ 
Découvrez une nouvelle façon d'obtenir des réponses à toutes vos questions ! 
Profitez des connaissances, des opinions et des expériences des internautes sur Yahoo! Questions/Réponses 
http://fr.answers.yahoo.com