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@redevox.com.br To: "Joao Pereira" joao.pereira@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@redevox.com.br To: serusers@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@lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers
Serusers mailing list serusers@lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers
-
Joao Pereira