Forum for PostgreSQL migration issues. http://forums.mysql.com/list.php?83 Tue, 24 Nov 2009 20:25:36 +0000 Phorum 5.2.1-alpha 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,289802,289802#msg-289802 http://forums.mysql.com/read.php?83,289802,289802#msg-289802
Big part of the Tungsten 1.2 launch is the all-new open source Tungsten Community Edition. All Tungsten components have 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 edition.

Continuent Tungsten harnesses 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 offers an easy to manage, dynamic database replication solution with automatic failover, cluster management, high availability and scalability for MySQL®, PostgreSQL, EnterpriseDB™ and Oracle®. Continuent Tungsten runs on all Linux™ and Solaris® platforms, and in the Amazon EC2™ cloud

Continuent Tungsten 1.2 is packed full with new features that make database clusters easier to administer and more stable. Tungsten 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 1.2 previews installation and management of clusters based on Oracle10g 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 and mission critical database applications using Tungsten and open source databases," said Eero Teerikorpi, CEO of Continuent. “We are offering a Community Edition as a free download, with an optional upgrade to the commercial Tungsten editions."

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 Fri, 06 Nov 2009 01:52:18 +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,275549,275549#msg-275549 http://forums.mysql.com/read.php?83,275549,275549#msg-275549
• Navicat Premium v.8.2.12 (Linux)
• Navicat for MySQL v.8.2.12 (Linux)
• Navicat for Oracle v.8.2.12 (Linux)
• Navicat for PostgreSQL v.8.2.12 (Linux)


These releases mark a complete Navicat product offering to the Linux users. Linux users can now experience the comprehensive database administration for MySQL, PostgreSQL and Oracle with Navicat.

Navicat Premium is a multi-connections Database Administration tool allowing you to connect to MySQL, PostgreSQL and Oracle databases simultaneously within a single application, making database administration to multiple kinds of database so easy. Navicat Premium combines the functions of other Navicat members together with below great features:

- Support of multi-connections to MySQL, PostgreSQL and Oracle servers.
- Support of transferring data across various database systems.
- Ability to transfer data to a text file with designated SQL format.
- Support of running profiles from different servers in a single schedule job.

New Features:

Support of latest MySQL versions

- Compatible with any MySQL server version.
- Support all MySQL objects: tables, views, stored procedures/functions and events.
- Support all sub-objects: fields, indices, foreign keys and triggers.
- Support of partitioning.
- Support of Unicode / Character Set.

Support of latest Oracle versions

- Support Oracle version 8.1, 9i, 10g and 11g.
- Support all Oracle objects: tables (Normal, External and Index Organized), views, procedures/functions.
- Support all sub-objects: fields, indices, foreign keys, uniques, checks and triggers.
- Managing directories, tablespaces, public database links and public synonyms.
- Managing database links, indices, java, materialized views, materialized view logs, packages, sequences, synonyms, triggers, types, XML Schema and Recycle Bin.
- Support of physical attributes.
- Support of Unicode/Character Set.

Support of latest PostgreSQL versions

- Support PostgreSQL Server version 7.3 to 8.3.
- Support all PostgreSQL objects: tables, views and functions.
- Support all sub-objects: fields, indices, foreign keys, uniques, checks, rules and triggers.
- Managing tablespace, cast and languages.
- Managing aggregates, conversions, domains, trigger functions, operators and classes, sequences and types.
- Support of character set and Unicode.

Connection options

- Support of password and public/private key for SSH Tunnel.
- Support of HTTP Tunnel for MySQL and PostgreSQL Servers.
- Support SSL secure connection for MySQL and PostgreSQL 8.4 above.

Well-designed user interface

- Grid View and Form View support.
- Virtual Grouping for connections and objects.

Powerful Data Manipulation Tools

- Import and Export tool.
- Data Transfer tool.
- Data and Structure synchronization.
- Backup and Restore.
- Ability to set schedule on backup, query execution, import/export, data transfer and data synchronization.
- Ability to attach Export Wizard/Report result files in Batch Job notification email.

SQL Processing

- Visual query/view builder to facilitate the process of building complicated queries.
- Ability to create parameter queries.
- Multiple SQL editors with syntax highlighted feature.
- Code completion for SQL editors.
- Ability to preview SQL before execution.
- Support to return multi-resultsets.


Download the 30-day Free Trial
========================================================================
To try the new Linux version of Navicat, please download the trial version at:

Navicat Premium v. 8.2 (Linux)
http://download.navicat.com/download/navicat8_premium_en.tar.gz

Navicat for MySQL v8.2 (Linux)
http://download.navicat.com/download/navicat8_mysql_en.tar.gz

Navicat for Oracle v8.2 (Linux)
http://download.navicat.com/download/navicat8_ora_en.tar.gz

Navicat for PostgreSQL v8.2 (Linux)
http://download.navicat.com/download/navicat8_pgsql_en.tar.gz


========================================================================
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.


Copyright 1999 - 2008. PremiumSoft ™ CyberTech Ltd All rights reserved
MySQL ™ is a trademark of MySQL AB in the United States and other countries]]> samnav sam PostgreSQL Tue, 11 Aug 2009 09:25:01 +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,248204,248204#msg-248204 http://forums.mysql.com/read.php?83,248204,248204#msg-248204
Navicat for MySQL is a graphical tool for managing, monitoring, and developing your MySQL database. This long-awaited release marks another enhanced experience of database administration for MySQL with Navicat™ for Mac Users.

The new release enhances the user experience of database administration such as support of Form View and Code Completion, this version also now supports import of data from ODBC source and supports the export of data to Excel spreadsheets.
Major new features include:
• Enhanced support of new MySQL server versions
• Partitioning support for MySQL 5.1
• Support of Form View
• Support of Code Completion in all SQL Editor
• Support of ODBC Import
• Support of exporting Excel file
• Support of View, Store Procedure and Event 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 all object design forms
• More table/column properties can be adjusted in Table design form
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 Tue, 17 Feb 2009 07:33:29 +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 http://forums.mysql.com/read.php?83,226469,226469#msg-226469 http://forums.mysql.com/read.php?83,226469,226469#msg-226469
Do Mysql Support these all ?]]> chetan padhye PostgreSQL Mon, 15 Sep 2008 09:17:18 +0000 http://forums.mysql.com/read.php?83,222509,222509#msg-222509 http://forums.mysql.com/read.php?83,222509,222509#msg-222509
i want to fetch 2 column as first in dataset wat can i do.


col1 col2 col3 col4
1 2 3 4
1 2 3 4

i want a query to fetch recordset like


col2 col1 col3 col4
2 1 3 4
2 1 3 4


but the select query must be written in sequence select col1,col2,col3,col4 .....]]> amit hasija PostgreSQL Thu, 14 Aug 2008 10:25:16 +0000 http://forums.mysql.com/read.php?83,218169,218169#msg-218169 http://forums.mysql.com/read.php?83,218169,218169#msg-218169
In Postgres, I used RAISE EXCEPTION 'my error text'; to throw an error when invalid data was being inserted into a table column (via a trigger). Pretty simple really. I thought ALL modern programming languages would have some support for error handling. Yet, here we are at version 5 of Mysql, and I find no way to throw an error in stored procedured or triggers. (I didn't find anything in the version 6 manual either) Can this be possible? I would have thought proper error handling would have been in version 1! WTF?

Any suggestions?

Thanks,
Dan]]> Dann Daggett PostgreSQL Sat, 12 Jul 2008 00:25:55 +0000 http://forums.mysql.com/read.php?83,212693,212693#msg-212693 http://forums.mysql.com/read.php?83,212693,212693#msg-212693
Navicat version 7 is a major new version with more than 100 significant improvements and many new features. To check out details, please see a release notes at: http://pgsql.navicat.com/release_notes_mac.html .

This PostgreSQL Client tool features an intuitive interface and provides a set of useful tool to manage, backup/ restore, import/ export data, Synchronize database and connect to remote PostgreSQL server, etc.

Primary features of Navicat 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

Please feel free to download at: http://pgsql.navicat.com/download.html.
To find out more details about the product, please visit at: http://pgsql.navicat.com/mac_detail.html

Navicat for MySQL can be found at: http://www.navicat.com/mac_detail.html]]> samnav sam PostgreSQL Thu, 05 Jun 2008 09:33:21 +0000 http://forums.mysql.com/read.php?83,206331,206331#msg-206331 http://forums.mysql.com/read.php?83,206331,206331#msg-206331
ALTER TABLE table_name
RENAME COLUMN "lock" TO is_locked;

Can you help me do this in MySQL?

ALTER TABLE table_name
CHANGE COLUMN lock is_locked character varying(3);

It doesn't work like this. I've also tried surrounding lock keyword with ' or ".]]> Matei Costescu PostgreSQL Wed, 23 Apr 2008 08:11:10 +0000 http://forums.mysql.com/read.php?83,206130,206130#msg-206130 http://forums.mysql.com/read.php?83,206130,206130#msg-206130 http://pgsql.navicat.com/release_notes_win.html.

Navicat PostgreSQL GUI Manager ver. 8 is the latest iteration of the database management tool that offers more than 100 improvements and some new powerful features. Major new features of ver. 8 at a glance:

Code Completion - Speedup your SQL writing.
Form View - Input record via form view.
New Profile System - Open profile on your desktop directly.
Virtual Grouping - Provides better categorization for objects.
Report Export - Export report to pdf, html and more.
E-mail Notification - Send notification e-mail for schedule task.

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 Sat, 23 May 2009 07:10:42 +0000 http://forums.mysql.com/read.php?83,199003,199003#msg-199003 http://forums.mysql.com/read.php?83,199003,199003#msg-199003 It is easy to create a new DB manually using MySQL admin tools.
However, I need to create one purely automatically.
When I try to open a Java Connection, the API call requires a DB name
as one of its parameters. Since the DB does not exist yet, I get an unknown database exception. No surprise, but I need to create a dummy
Connection that I can use to execute a Java Statement instance containing
the desired SQL Create Database command?


Is there a way to do this or is it necessary to create the database manually

Thanks]]> Richard Adler PostgreSQL Mon, 03 Mar 2008 19:13:46 +0000 http://forums.mysql.com/read.php?83,197589,197589#msg-197589 http://forums.mysql.com/read.php?83,197589,197589#msg-197589 John Beck PostgreSQL Fri, 22 Feb 2008 14:36:38 +0000 http://forums.mysql.com/read.php?83,185772,185772#msg-185772 http://forums.mysql.com/read.php?83,185772,185772#msg-185772
http://www.nabble.com/Re%3A-postgresql-vs-mysql-p9083612.html

In particular, it is absurd that MySQL rebuilds all indexes for InnoDB tables on any trivial "alter table".

So please let me know if there are any serious problems with PostgreSQL that caused you to migrate to MySQL.]]> Franklin Schmidt PostgreSQL Fri, 30 Nov 2007 20:10:14 +0000 http://forums.mysql.com/read.php?83,181804,181804#msg-181804 http://forums.mysql.com/read.php?83,181804,181804#msg-181804
I have a PostGis database which has some data as type Geometry.
I'm sure there is a more elegant way but I just created the tables again in MySQL and then did a search and replace in the SQL dump from PostGIS so that I could insert the values into MySQL.
Unfortunately, it doesn't seem to like the geometry data which is expressed as '010100000089416065572920410AD7A370A9A6FA40'.
The exact error message is: "Data truncation: Cannot get geometry object from data you send to the GEOMETRY field"
I'm not sure if MySQL stores geometry data in this way... Does anyone know a way of converting the geometry data so that it can be stored in MySQL?


Thanks,

NP]]> n p PostgreSQL Sun, 03 Feb 2008 12:13:03 +0000 http://forums.mysql.com/read.php?83,181507,181590#msg-181590 http://forums.mysql.com/read.php?83,181507,181590#msg-181590 neel ninawe PostgreSQL Tue, 06 Nov 2007 11:37:26 +0000 http://forums.mysql.com/read.php?83,173895,173895#msg-173895 http://forums.mysql.com/read.php?83,173895,173895#msg-173895
I am hoping that I can create one or more .csv files for this purpose. Has anyone here done this - moved from PG to mysql? Does anyone know of any papers, best practice type guidelines, etc. that I could follow?

Thanks
Marc]]> Marc Maxwell PostgreSQL Fri, 12 Oct 2007 17:39:48 +0000 http://forums.mysql.com/read.php?83,173895,173911#msg-173911 http://forums.mysql.com/read.php?83,173895,173911#msg-173911 Marc Maxwell PostgreSQL Tue, 18 Sep 2007 18:29:43 +0000 http://forums.mysql.com/read.php?83,166534,166534#msg-166534 http://forums.mysql.com/read.php?83,166534,166534#msg-166534
I am trying to migrate a subset of the tables from a postgres database to
mysql. I used the postgres dumpfile and the lightbox tool to create
the equivalent tables in mysql. The postgres dump file adds the foreign key columns separately from the create column description.

For example postgres table "file" contains:

CREATE TABLE file (
coreobjectid integer NOT NULL,
fullpath character varying(255),
filename character varying(255),
url character varying(255)
);

...

...

ALTER TABLE ONLY file
ADD CONSTRAINT file_pkey PRIMARY KEY (coreobjectid);


ALTER TABLE ONLY file
ADD CONSTRAINT "$1" FOREIGN KEY (coreobjectid) REFERENCES coreobject(id) ON UPDATE NO ACTION ON DELETE NO ACTION DEFERRABLE INITIALLY DEFERRED;



Some entries from the postgres table "file"

17030 -1 \N \N \N
36829 739 \N Biochemistry_v38_p13592-13601.pdf \N
81743 2653 \N Bioinformatics_v17_p763-774.pdf \N
36908 746 \N Manipulation of standard deviations_1.doc \N

How do I import the foreign key relationships into mysql?]]> Joe Toth PostgreSQL Wed, 15 Aug 2007 17:36:16 +0000