You are viewing a plain text version of this content. The canonical link for it is here.
Posted to ddlutils-user@db.apache.org by Laurent ROCHE <la...@yahoo.com> on 2006/11/15 20:46:30 UTC

Are domains supported ?

Hi,

I am new here and to the Apache world in general, so appologies, if I ask for the obvious.

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 ?

I can modify the xml file by search and replace but not for everything. And this migration is not a one off, as we have a centralised Postgres database replicating with many Derby dbs ... so we need to be able to regenerate the Derby dbs everytime we are going to change the schema of the Postgres db.

 
Cheers,
L@u
The Travelling Froggy
TravellingFroggy.info




	

	
		
___________________________________________________________________________ 
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

Re: Are domains supported ?

Posted by "Jean T. Anderson" <jt...@bristowhill.com>.
Laurent ROCHE wrote:
> Hi,
> 
> I am new here and to the Apache world in general, so appologies, if I ask for the obvious.
> 
> 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 ?


Would it help to know that Derby doesn't support the "create domain"
statement? Derby does support tables, indexes, views, synonyms, schemas,
functions, procedures, and triggers -- see
http://db.apache.org/derby/docs/10.2/ref/ .

regards,

 -jean


> I can modify the xml file by search and replace but not for everything. And this migration is not a one off, as we have a centralised Postgres database replicating with many Derby dbs ... so we need to be able to regenerate the Derby dbs everytime we are going to change the schema of the Postgres db.
> 
>  
> Cheers,
> L@u
> The Travelling Froggy
> TravellingFroggy.info
> 
> 
> 
> 
> 	
> 
> 	
> 		
> ___________________________________________________________________________ 
> 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

Re: Are domains supported ?

Posted by Thomas Dudziak <to...@gmail.com>.
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