[Serusers] mysql or postgres database

[Joao Pereira]

Thanks for your help
I manually changed the tables from MySql to Postgres... but in the
"ser_mysql.sh" there are no links (foreign keys) between the tables, maybe
because MySQl dont have control over it.... but Postgres have, and would be
cool to have correct foreign keys in the Postgres database. Is there any
place in the distribution or in some web page that have the foreign keys
between the tables.

Obrigado
João Pereira

PS: não existirão listas destas em Portugues? :P



----- Original Message -----
From: "Welesley Sibelson Dias" <leley.dias at redevox.com.br>
To: "Joao Pereira" <joao.pereira at fccn.pt>
Sent: Monday, January 17, 2005 11:05 AM
Subject: Re: [Serusers] mysql or postgres database


Joao No... :(
i have one script copy_to_pgsql do you first create tables in mysql and
convert to pgsql
but Joao it easy find one converter of mysql to pgsql tables.

Em Seg 17 Jan 2005 12:52, você escreveu:
> Thank you very much...
> and is there any place in the distribution with the DB tables in Postgres?
>
> Joao
>
>
> ----- Original Message -----
> From: "Welesley Sibelson Dias" <leley.dias at redevox.com.br>
> To: <serusers at lists.iptel.org>
> Sent: Monday, January 17, 2005 10:29 AM
> Subject: Re: [Serusers] mysql or postgres database
>
> > Joao
> > into directory modules/postgres
> > exist one script serpgctl it serctl to postgres
> >
> > Em Seg 17 Jan 2005 12:15, Joao Pereira escreveu:
> > > Hi
> > > I m already using a Postgres database in my PC and now I wanted to
>
> connect
>
> > > SER with it, but serctl and all the SER arquitecture is in MySql. I
> > > have SER already using a postgres SQL for registering and accounting,
> > > but
>
> with
>
> > > serctl is more dificult....  Should I insist in postgres because SER
>
> really
>
> > > supports it or should I give up and install mysql??
> > >
> > > Thaks
> > > Joao
> > >
> > > _______________________________________________
> > > Serusers mailing list
> > > serusers at lists.iptel.org
> > > http://lists.iptel.org/mailman/listinfo/serusers
> >
> > _______________________________________________
> > Serusers mailing list
> > serusers at lists.iptel.org
> > http://lists.iptel.org/mailman/listinfo/serusers