Re: [Serusers] mysql or postgres database - sr-users

18 Jan 2005

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" &lt;leley.dias(a)redevox.com.br&gt;
To: "Joao Pereira" &lt;joao.pereira(a)fccn.pt&gt;
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" &lt;leley.dias(a)redevox.com.br&gt;
 To: &lt;serusers(a)lists.iptel.org&gt;
 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(a)lists.iptel.org
 > > http://lists.iptel.org/mailman/listinfo/serusers
 >
 > _______________________________________________
 > Serusers mailing list
 > serusers(a)lists.iptel.org
 > http://lists.iptel.org/mailman/listinfo/serusers 