Forum for PostgreSQL migration issues. http://forums.mysql.com/list.php?83 Sat, 25 May 2013 18:17:30 +0000 Phorum 5.2.19 http://forums.mysql.com/read.php?83,570604,570604#msg-570604 http://forums.mysql.com/read.php?83,570604,570604#msg-570604
I got a postgre v8.3 DB server used only for basic storage like, name, surname, email, comments. This is available only for my intranet, so, access denied from outside.

I need to set up forms using this data but my postgreSQL is old and I can't change it or upgrade it(internal polices...)

I'm planning to rent a cPanel with DB. and use that mYsql as my database server.

BUT I need the data from the older PostgreSQL and I need to keep using the old for my actual old systems.

So, this is the question, can I create the mYsql database to work as a mirror? all the data inserted on PostgreSQL automatically go to mYsql and is ready to use it.

The use of this "new data" is only queries to the database to show the specific fields.

I'm not planning to feed the Database through mYsql, only on PosgreSQL.

Can I do that?, do you have the any help for this?

Much appreciated.

Let me know if it is not clear.]]> walter catter PostgreSQL Wed, 10 Oct 2012 08:57:32 +0000 http://forums.mysql.com/read.php?83,564775,564775#msg-564775 http://forums.mysql.com/read.php?83,564775,564775#msg-564775

CREATE OR REPLACE FUNCTION ins_Periods() RETURNS trigger AS $$
BEGIN
INSERT INTO Period_Tax_Types (Period_ID, Tax_Type_ID, Period_Tax_Type_Name, Formural, tax_relief, percentage, linear, Employer, Employer_PS, Tax_Type_order, In_Tax, account_number)
SELECT NEW.Period_ID, Tax_Type_ID, Tax_Type_Name, Formural, tax_relief, percentage, linear, Employer, Employer_PS, Tax_Type_order, In_Tax, account_number
FROM Tax_Types
WHERE (active = true);

INSERT INTO Employee_Month (Period_ID, pay_group_ID, Entity_ID, Bank_Branch_ID, Department_Role_ID, Bank_Account, Basic_Pay)
SELECT NEW.Period_ID, 0, Entity_ID, Bank_Branch_ID, Department_Role_ID, Bank_Account, basic_salary
FROM Employees
WHERE (active = true);

PERFORM updTax(employee_month_id, Period_id)
FROM employee_month
WHERE (period_id = NEW.period_id);

RETURN NULL;
END;


thanks in anticipation]]> ayuba isa PostgreSQL Sun, 12 Aug 2012 12:03:57 +0000 http://forums.mysql.com/read.php?83,562706,562706#msg-562706 http://forums.mysql.com/read.php?83,562706,562706#msg-562706 - Download: http://dev.mysql.com/downloads/workbench/
- Docs: http://dev.mysql.com/doc/workbench/en/wb-migration.html
- Migration from PostgreSQL (versions: )

PostgreSQL migration:
http://mysqlworkbench.org/2012/11/how-to-migrate-postgresql-databases-to-mysql-using-the-mysql-workbench-migration-wizard/
http://mysqlworkbench.org/2012/11/set-up-and-configure-postgresql-odbc-drivers-for-the-mysql-workbench-migration-wizard/


Presentations:
http://www.slideshare.net/mdg149/migrating-from-postgresql-to-mysql-without-downtime


Blogs:
http://www.codesmell.org/blog/2009/03/migrate-data-from-postgres-to-mysql/]]> Edwin Desouza PostgreSQL Wed, 25 Jul 2012 03:37:58 +0000 http://forums.mysql.com/read.php?83,550898,550898#msg-550898 http://forums.mysql.com/read.php?83,550898,550898#msg-550898
I have designed a database in postgres but now i want to import the same to mysql.When i tried to import i got the following error

"/SQL query:
--
-- PostgreSQL database dump
--
SET statement_timeout =0;
MySQL said:
#1193 - Unknown system variable 'statement_timeout' /"

I dont know what is the error and how to solve it.Plzz help me]]> archana k PostgreSQL Wed, 06 Jun 2012 05:26:10 +0000 http://forums.mysql.com/read.php?83,525487,525487#msg-525487 http://forums.mysql.com/read.php?83,525487,525487#msg-525487 i've created the virtual machine with postgres and mysql ,
the wizard of migration tooltoolkit say me that general jdbc ,i download the jar of postgres where should I put ,and there are another parameters such as the connection string ?
can you help me?
Thanks you
Regards
Francesco]]> Francesco Itollo PostgreSQL Fri, 27 Apr 2012 16:09:58 +0000 http://forums.mysql.com/read.php?83,519326,519326#msg-519326 http://forums.mysql.com/read.php?83,519326,519326#msg-519326
I'm trying to migrate my db in Postgres in mysql.
But i have a problem
When i must choosing the database doesn't found the "Postgres" .

How i can to migrate Postgres in Mysql using mysql migraton tools?

thank you for help
regards
Francesco]]> Francesco Itollo PostgreSQL Sat, 02 Jun 2012 17:06:23 +0000 http://forums.mysql.com/read.php?83,407304,407304#msg-407304 http://forums.mysql.com/read.php?83,407304,407304#msg-407304 Register at https://www1.gotomeeting.com/register/353509496

Countless petabytes of data are sitting in MySQL database where they are perfectly useless for PostgreSQL users. Fortunately there is a solution: Tungsten Replicator can move data from MySQL to PostgreSQL and Greenplum, and in real time, too.

In this webcast we'll describe how to design cross-database replication, then set it up using Tungsten Replicator. We will cover some of the pitfalls and corner cases like SQL dialect differences, data types, character sets, and MySQL bugs that make implementation both exciting and fun.

We'll conclude with a demo of database updates moving in real time between databases.

Register for this free webinar at https://www1.gotomeeting.com/register/353509496.]]> Petri Virsunen PostgreSQL Fri, 11 Feb 2011 20:53:44 +0000 http://forums.mysql.com/read.php?83,401344,401344#msg-401344 http://forums.mysql.com/read.php?83,401344,401344#msg-401344
"transition of the system from MySQL to postgres, better would be to make the database connection abstract completely, so if a client decides to buy it and connect it to an oracle database, we don't care."

The program currently uses simple queries like:

query << "delete from " << MN << "import";

query << "load data local infile '" << impFile << "' into table " << MN << "import fields terminated by ','";

query << "select count(distinct SLIP), count(distinct SLP_ID) from " << MN << "import";

query << "select TRAD from " << MN << "import where SLIP =" << clslip;





There are no joins etc anywhere involved in the current application and above are the only queries used in the application that are to be converted to postgres.

I am in real trouble .. Please Help me out . i be greatful to you.
regards,
A.Q.Ghouri]]> Qadeer Ghouri PostgreSQL Tue, 04 Jan 2011 07:34:20 +0000 http://forums.mysql.com/read.php?83,399375,399375#msg-399375 http://forums.mysql.com/read.php?83,399375,399375#msg-399375
I was hoping someone could give me some advice, I have a requirement to "parse" a Postgresql (not migrate) database (single database) into an equivalent MySQL database to be used offline for another purpose, the way that I have it working now is like this:

1) Perl (DBI) script executes every 40mins performs a SELECT on the SOURCE tables and INSERTS into MySQL (DESTINATION)

Problems I have and "not sures":

1) In my script I had to specify ALL of the column names to SELECT on (big long list) and ALL of the column names again to INSERT on (can I not just perform a SELECT * and then INSERT *?? I couldn't get this to work)

2) The SOURCE DATABASE automatically updates once every 30mins, so my script runs just after this is complete (different scheduler, not the same, so we hope they don't overlap - this is not ideal)

3) Must I use SELECT // INSERT? is this the only way? it is very slow (at the Postgresql end :-) ) is there a more efficient method? (I am using filters in my TSQL on the POSTGRESQL end but I dont need to, I only did this to cut down the query time!)

I did consider using ODBC but I'm not seeing any benefit of using this instead of the above.

Thanks all - any input would be greatfully appreciated]]> Martin Thorpe PostgreSQL Fri, 17 Dec 2010 07:26:18 +0000 http://forums.mysql.com/read.php?83,393486,393486#msg-393486 http://forums.mysql.com/read.php?83,393486,393486#msg-393486
Algunos de los temas aproximados a ver son:

Conocimientos Escenciales:
Introducción al Modelo Relacional, Arquitectura Cliente/Servidor
Breves comparaciones, Postgresql
Procesamiento interno y Arquitectura
Instalación
Configuración Básica del servidor y conexiones

Elementos y Administración Básicos:
Herramientas y programas estándar: PgAdmin III y psql
Migraciones de versión
Monitoreo
Mantenimiento
Respaldos
Transacciones
Entendiendo el funcionamiento de la WAL
Control de concurrencias
PITR y nociones de replicación básicas

SQL y lenguajes:
SQL Estándar (DDL y DML), PL/pgsql, objetos y jerarquia
Funciones
Introducción PL/Perl y PL/Pythonu

Elementos de Seguridad:
Seguridad en PostgreSQL
Roles: Usuarios y Grupos
Esquemas y Permisos
Vistas y Reglas
Seguridad de Datos
Comunicaciones y conexiones remotas
Restricciones a través de la configuración
Autenticación y encriptación

Elementos de Performance:
Entendiendo el EXPLAIN
Estadísticas
Afinando servidores dedicados y de desarrollo
Tuning de Consultas SQL
Optimización y técnicas de performance
Conceptos básicos de Full Text Search

Se recomienda que los que asistan tengan conocimientos de SQL básico. Es recomendable que también tengan conocimientos básicos de Linux o Windows (es decir, una plataforma de Sistema Operativo).

El día Viernes 22 de Octubre se dió una breve introducción al curso y a Postgresql 9.0. Si querés ver la charla completa acccede al siguiente link: http://connectpro65421913.emea.acrobat.com/p67117135/

Interesados en más información, enviar un mail a silvia.igon [en] gmail.com o silvia(at)emanuelcalvofranco(at)com(at)ar coordinadora de cursos, referenciando como instructor a Emanuel Calvo Franco.

También estamos organizando una serie de charlas técnicas gratuitas y abiertas. Esten al tanto de las fechas en: http://www.emanuelcalvofranco.com.ar/livestream.html#]]> Emanuel Calvo Franco PostgreSQL Sun, 07 Nov 2010 15:55:40 +0000 http://forums.mysql.com/read.php?83,393080,393080#msg-393080 http://forums.mysql.com/read.php?83,393080,393080#msg-393080 How can i do that?
If i completely convert postgresql db to mysql db ,then it is also good..How to do that?]]> Akash Chandran PostgreSQL Tue, 09 Nov 2010 23:08:53 +0000 http://forums.mysql.com/read.php?83,388679,388679#msg-388679 http://forums.mysql.com/read.php?83,388679,388679#msg-388679
Thanks,
Charmie]]> charmie maniar PostgreSQL Fri, 17 Dec 2010 07:29:10 +0000 http://forums.mysql.com/read.php?83,383218,383218#msg-383218 http://forums.mysql.com/read.php?83,383218,383218#msg-383218
I tried to switch my application from postgres to mysql. The problem is i don't know how to change below sql query to mysql.

UPDATE datavalue as d1 SET value=d2.value,storedby=d2.storedby,lastupdated=d2.lastupdated,comment=d2.comment,followup=d2.followup FROM datavalue AS d2 WHERE d1.periodid=d2.periodid AND d1.sourceid=d2.sourceid AND d1.lastupdated<d2.lastupdated AND d1.dataelementid=1 AND d1.categoryoptioncomboid=2 AND d2.dataelementid=3 AND d2.categoryoptioncomboid=4;

I was wondering if you guys can help me out.
Thank you very much!
Best regards,
Quang]]> Quang Nguyen PostgreSQL Mon, 06 Sep 2010 07:18:53 +0000 http://forums.mysql.com/read.php?83,378546,378546#msg-378546 http://forums.mysql.com/read.php?83,378546,378546#msg-378546
SELECT * FROM users WHERE EXISTS (SELECT * FROM questions JOIN answers ON answers.owner_id = users.id);

I results in

ERROR 1054 (42S22): Unknown column 'users.id' in 'on clause'

Note: I can make the simplified query work by changing it to

SELECT * FROM users WHERE EXISTS (SELECT * FROM questions JOIN answers WHERE answers.owner_id = users.id);

However that's not possible for my original query - I'm making LEFT OUTER JOIN with a few conditions and select only records where answers.id IS NULL.

In case it matters I'm using MySQL 5.1.46 on Gentoo Linux. Could you help me to fix this?]]> Joachim Bartosik PostgreSQL Fri, 30 Jul 2010 13:29:37 +0000 http://forums.mysql.com/read.php?83,293151,293151#msg-293151 http://forums.mysql.com/read.php?83,293151,293151#msg-293151
i would like to know if there is a way i could migrate data from my old PgSQL database to a new MySQL database with a slightly different schema.

i am aware that i can use scripts to convert from pgsql to mysql, however, as i've already mentioned, there has been a slight change in the database schema and i'm also using an old pgsql version.

any advice on how i could migrate my data? Thanks.]]> Greg Hermo PostgreSQL Fri, 11 Dec 2009 08:52:59 +0000 http://forums.mysql.com/read.php?83,293146,293146#msg-293146 http://forums.mysql.com/read.php?83,293146,293146#msg-293146
i would like to know if there is a way i could migrate data from my old PgSQL database to a new MySQL database with a slightly different schema.

i am aware that i can use scripts to convert from pgsql to mysql, however, as i've already mentioned, there has been a slight change in the database schema and i'm also using an old pgsql version.

any advice on how i could migrate my data? Thanks.]]> Greg Hermo PostgreSQL Fri, 27 Nov 2009 08:46:37 +0000 http://forums.mysql.com/read.php?83,290570,290570#msg-290570 http://forums.mysql.com/read.php?83,290570,290570#msg-290570
Tungsten Community Edition harnesses the latest innovations from the open source database clustering community with no up-front acquisition costs, and provides a clear path to more advanced capabilities through an optional upgrade to the commercial Tungsten Enterprise editions.

All Tungsten components have previously been available as open source, but with Tungsten Community Edition they become far more easily accessible with complete builds, easy installation and configuration together with complete set of documentation. Tungsten Community Edition is available free of charge, while customers who want more advanced features and on-call technical support are encouraged to purchase the commercial Tungsten Enterprise editions.

Continuent’s commercial Tungsten Enterprise editions combine the power of open source and commercial technologies to deliver data availability solutions that are based on the Tungsten open source components, a unique collection of solutions for database scale-out. Continuent Tungsten Enterprise 1.2 is packed full with new features that make database clusters easier to administer and more stable. Tungsten Enterprise 1.2 includes Beta support for managing clusters based on PostgreSQL warm standby. PostgreSQL support includes provisioning of clusters, simple failover procedures, and backup/restore. In addition, Tungsten Enterprise 1.2 previews installation and management of clusters based on Oracle® 10g running on Linux™.

“Continuent Tungsten allows database administrators to implement simple, powerful and affordable data availability and database performance solutions. Our customers significantly lower their TCO on business critical database applications using Tungsten and open source databases,” said Eero Teerikorpi, CEO of Continuent. “We are very pleased to offer Continuent Tungsten Community Edition as a free open source solution.”
A free Tungsten Community Edition is available at http://www.continuent.com.

About Continuent
Continuent, the leading provider of data availability and database performance scalability solutions, offers database high availability and incremental performance scaling using commodity hardware and databases. We provide continuous uptime so you can deliver business critical database applications with high data availability and accessibility. We also offer support, training and consulting services to our customers worldwide.

Continuent’s Tungsten solutions provide a unique collection of technologies for database scale-out. Tungsten core stack is 100% open source. Tungsten is operating system independent and supports both commercial and open source databases including Oracle, MySQL, PostgreSQL and EnterpriseDB™. For more information about Continuent and our products, visit www.continuent.com.

Press Contacts
pr@continuent.com]]> Petri Virsunen PostgreSQL Wed, 11 Nov 2009 02:20:56 +0000 http://forums.mysql.com/read.php?83,288236,288236#msg-288236 http://forums.mysql.com/read.php?83,288236,288236#msg-288236 I want to migrate our database from postgresql to mysql.If you know any migration tool or any methodology then please reply.......]]> Mahendra Bagul PostgreSQL Mon, 02 Nov 2009 07:47:53 +0000 http://forums.mysql.com/read.php?83,278004,278004#msg-278004 http://forums.mysql.com/read.php?83,278004,278004#msg-278004
I does not arrive a backup of PostgreSQL and to recover in Mysql.
I have generate a script in PostgreSQL but it function not in Mysql.
How to make?

Excuse me for the syntax errors, I'am french]]> PIERRAT François PostgreSQL Wed, 26 Aug 2009 07:06:44 +0000 http://forums.mysql.com/read.php?83,276739,276739#msg-276739 http://forums.mysql.com/read.php?83,276739,276739#msg-276739
searching for best way to check how postreSQL service working on web server. Sometimes it shows that it is working, but from user we are getting reports that it doesn't.
We have six servers and need best way to check it regularly.]]> Tomas K PostgreSQL Sun, 06 Sep 2009 08:28:22 +0000 http://forums.mysql.com/read.php?83,272842,272842#msg-272842 http://forums.mysql.com/read.php?83,272842,272842#msg-272842
NaviCoder Editor is a professional source code editor for Windows and is useful for people who work with various programming environments, its supports various programming languages/ script files such as HTML, C/C++, Perl, Phython, Java, PHP, ASP, VBScript and more, up to 46 types.

NaviCoder Editor is written in C++ and professionally designed for the best look and feel. It is not only fast in loading time and occupying less memory, but also small in size, making it a stable and powerful tool.
Feature highlights:
1. Edit multiple documents.
2. Syntax Highlighting and Syntax Folding.
3. Brace and Indent guideline Highlighting.
4. Zoom in and zoom out.
5. Bookmarking.
6. and more….

To download this freeware, please visit: http://www.navicoder.com/download.html]]> samnav sam PostgreSQL Wed, 22 Jul 2009 10:50:08 +0000 http://forums.mysql.com/read.php?83,268341,268341#msg-268341 http://forums.mysql.com/read.php?83,268341,268341#msg-268341
Navicat Premium combines the functions of other Navicat members, allowing user to connect to MySQL, PostgreSQL and Oracle databases within the same application. With connections established to different database types, Navicat Premium supports data transfer between MySQL, PostgreSQL and Oracle. Batch job for different databases can also be scheduled and run at a specific time.

With different connection established, Navicat Premium is an ALL-IN-ONE application to manage your MySQL, PostgreSQL and Oracle databases. Other features include Import/ Export Wizard, Query Builder, Report Builder, Data Synchronization, Backup, Job Scheduler and more.

“Navicat Premium is a significant milestone in our software development, fulfilling our mission to deliver more software which enhance productivity and maximize results for our customers. With Navicat Premium ability to connect to databases of different types, it makes the database administration of multiple databases easier than ever.” said Ken Lin, Software Development Director.

Navicat Premium prices start from US$149, currently available for Microsoft Windows and Mac OS X, supporting simultaneously connections to MySQL, PostgreSQL and Oracle databases.

For more details, please see the release notes at http://www.navicat.com/products/navicat_premium
Or, download the 30-day fully functional free trial at: http://www.navicat.com/download




About PremiumSoft CyberTech Limited:
PremiumSoft was founded in 1999 and is a fast growing company, aiming at accelerating application development and database management with software that enhance productivity and maximize results of our customers. With our customer-centric focus and best-of-breed products and services, PremiumSoft has been successful in making customers significantly more productive.]]> samnav sam PostgreSQL Mon, 22 Jun 2009 10:30:15 +0000 http://forums.mysql.com/read.php?83,259986,259986#msg-259986 http://forums.mysql.com/read.php?83,259986,259986#msg-259986
• Navicat for Oracle (Mac OS X) Version 8.0.6
• Navicat for PostgreSQL (Mac OS X) Version 8.0.6
• Navicat for MySQL (Mac OS X) Version 8.0.6

Navicat is a fast and affordable database administration tool, currently available for MySQL, PostgreSQL or Oracle database. It is a graphical tool for managing, monitoring, and developing your Oracle database.
The new release enhances the user experience of database administration and fine tunes many of the operations.

Navicat for Oracle v8.0.6 is a major release from PremiumSoft. The Enterprise Edition offers advance features including Visual Query Builder, Report Builder, Data Synchronization, Back up Tool and Scheduler to allow you managing your Oracle database more efficiently and easier.
Other features in Navicat for Oracle include Visual User Manager, SQL Console and SQL Preview in Table View.
Below shows the major enhancements in the new release of Navicat for Oracle (Mac OS X) Version 8.0.6:
• Support of exporting Excel file
• Support of ODBC Import
• Support of Form View
• Support of Simple Code Completion in SQL Editor
• Ability to send notification e-mail for schedule task, with an option to attach file from Export Wizard
• Support of creating table, view, import/export profile shortcuts on desktop

Besides, the release of Navicat for PostgreSQL v8.0.6, also marks another enhanced user experience of database administration on PostgreSQL databases. In this new version, the following enhancements have been made:
• Enhanced support of PostgreSQL version 7.3 to 8.3
• Support of Form View
• Support of Code Completion in all SQL Editor
• Support of ODBC Import
• Support of exporting data to Excel file
• Support of View, Store Procedure, Sequence, etc, in Structure Synchronization
• Ability to send notification e-mail for schedule task, with an option to attach file from Export Wizard
• Support of creating table, view, import/export profile shortcut on desktop
• Support of SQL Preview for object design forms
For more details on software releases, please see the release notes at http://oracle.navicat.com/soft_update_mac.html
Or, download the 30-day fully functional free trial at: http://www.navicat.com/download.html.]]> samnav sam PostgreSQL Tue, 28 Apr 2009 04:06:11 +0000 http://forums.mysql.com/read.php?83,253709,253709#msg-253709 http://forums.mysql.com/read.php?83,253709,253709#msg-253709
I'm currently developing a program for centralizing the vehicle fleet GPS information -http://openggd.sourceforge.net-, written in C++.

The database should have these requirements:

- The schema for this kind of data consists of several arguments -latitude, longitude, time, speed. etc-, none of them is a text field.
- The database also should create a table for every truck -around 100 trucks-.
- There won't be more than 86400 * 365 rows per table -one GPS position every second along one year-.
- There won't be more than 10 simultaneously read-only queries.

The question is: Which DBMS do you think is the best for this kind of application? PostgreSQL or MySQL?


Thanks in advance

Juan Karlos]]> juan carlos PostgreSQL Fri, 20 Mar 2009 13:57:54 +0000 http://forums.mysql.com/read.php?83,247727,247727#msg-247727 http://forums.mysql.com/read.php?83,247727,247727#msg-247727
Has anyone made this transition and have any pointers for me or can anyone give me a heads up that will save me some time?

Just looking for simple feedback, thanks..

-John]]> john henderson PostgreSQL Mon, 13 Apr 2009 13:34:38 +0000 http://forums.mysql.com/read.php?83,241187,241187#msg-241187 http://forums.mysql.com/read.php?83,241187,241187#msg-241187 Navicat for MySQL is a graphical tool for managing, monitoring, and developing your MySQL database. This new release enhances the performance of data transfer from one database to another, as well as the importing feature. Other functions include:

- Visual Query Builder
- SSH/ HTTP tunneling for remote database connectivity
- Server-to-server database transfers
- Data and Structure Synchronization
- Data backup and restore
- Import/ Export of most popular data formats to and from MySQL
- Tasks Scheduling and easy-to-use "wizards" designed to walk users through the steps of migrating CSV, DBF, TXT, XML, or other data formats to MySQL

For more details, please see the release notes at http://mysql.navicat.com/release_notes_mac.html.
Or, download the 30-day fully functional free trial at: http://mysql.navicat.com/download.html.]]> tam navicat PostgreSQL Wed, 07 Jan 2009 08:20:36 +0000 http://forums.mysql.com/read.php?83,239716,239716#msg-239716 http://forums.mysql.com/read.php?83,239716,239716#msg-239716
I need to convert the following code from PostgreSQL into MySQL

Code:

CREATE TYPE type_name AS
(
field_id INTEGER,
field_name VARCHAR(50)
);


CREATE FUNCTION function_name()
RETURNS SETOF type_name LANGUAGE plpgsql AS $$
DECLARE
variable_name type_name;
BEGIN
FOR variable_name IN
SELECT field_id, field_name
FROM table_name
ORDER BY field_id
LOOP
RETURN NEXT variable_name;
END LOOP;
END;
$$;


SELECT * FROM function_name();


Can anybody help?


Thanks in advance!]]> Dana Zon PostgreSQL Tue, 23 Dec 2008 13:35:30 +0000 http://forums.mysql.com/read.php?83,238805,238805#msg-238805 http://forums.mysql.com/read.php?83,238805,238805#msg-238805
I am moving a database and website from PGSQL to MySQL. I am concerned with some searching anomalies that I have encountered with MySQL.

In the Postgres version, any and all searches of the database were performed by basically the same line:
select * from {table} where {colunm} ~* {data};

In MySQL, that would be:
select * from {table} where {column} LIKE {data};

This works for some but not all searches, and trying out the MATCH AGAINST words are also showing inconsistency. For instance:

Given a row with the following:
|oid | network | ip_address |asgnmt|comments|cont|hcd |
+-----------+------------------+---------------+------+--------+----+----+
|00000001999|192.168.000.000/24|192.168.000.001| NULL | modems |NULL|NULL|

select * from detail where match oid against ('00000001*' IN BOOLEAN MODE);
~snip~
1000 rows in set (0.04 sec)

select * from detail where oid like '00000001*';
Empty set (0.03 sec)

HOWEVER, given the same row structure:

select * from detail where match network against ('192.168.000.000/24' IN BOOLEAN MODE);
Empty set (0.02 sec)

select * from detail where network like '192.168.000.000/24';
~snip~
256 rows in set (0.02 sec)

All fields are varchar in this database.

Can someone please explain the glaring mutually-exclusive difference here? And why can't I use just one, as in Postgres?

Thanks,

Alex]]> Alex Moen PostgreSQL Tue, 16 Dec 2008 20:48:10 +0000 http://forums.mysql.com/read.php?83,229874,229874#msg-229874 http://forums.mysql.com/read.php?83,229874,229874#msg-229874 I am new to MySQL.
I am having a PostgreSQL Database, and i want to convert it to MySQL.
I have tried the lightbox website, but there is one problem i am facing,
I have coulple of Functions and triggers as well which i am not able to convert.

Is there any tool or website whihc converts the complete DB Structure including functions/stored proc/triggers and everything to MySQL.

Thanks a ton.]]> Deepak Surana PostgreSQL Sat, 11 Oct 2008 07:44:28 +0000 http://forums.mysql.com/read.php?83,227031,227031#msg-227031 http://forums.mysql.com/read.php?83,227031,227031#msg-227031 Navicat features an intuitive interface and provides a set of useful tool to import/ export, backup/ restore data, Synchronize database and connect to remote PostgreSQL server, etc.

Major new features:
Code Completion - speedup your sql writing.
Form View - enjoy a clear display of field name and its value with focus on current record.
New Profile System - Open profile on your desktop directly.
Print Report to Files - export report to pdf, html and more.

Other enhancements:
Incremental Search and more supports in Table View. Usability enhancement in Table Design. Many other improvements on features and user-friendliness. Download full version at http://pgsql.navicat.com/download.html

To find out more details about the product, please visit at: http://pgsql.navicat.com/detail.html
Navicat for MySQL can be found at: http://www.navicat.com]]> samnav sam PostgreSQL Fri, 19 Sep 2008 06:58:12 +0000