Migrate Mysql to postgresql database issue

From: Gaurav Agrawal <gaurav(dot)agrawal(at)kiwitech(dot)com>
To: pgsql-in-general(at)postgresql(dot)org, pgsql-in-general-owner(at)postgresql(dot)org
Cc: Shyam Krishna Sharma <shyam(dot)sharma(at)kiwitech(dot)com>
Subject: Migrate Mysql to postgresql database issue
Date: 2016-07-25 14:10:16
Message-ID: CANrFDBn25QR6EJuPB2wqd0fGwY4prqgYr9CAkr53s686rbfwHA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-in-general

Hi PGSQL Team,

I migrate mysql databse to postgresql database but I face the following
issues while inserting or fetching data when I connect and run my existing
PHP YII framework application with postgresql database:
(1) NOT NULL constraint violation for most of the columns
(2) unserialize error offset when serialize/unserialize data. Even the
column type I altered as bytea from text.

Please suggest appropriate solution or some useful resources having migrate
database information and issues.

Best Regards
Gaurav Agrawal

--

************************************************************************

*This e-mail and all attachments are intended solely for use by the
intended recipient and may contain confidential / proprietary information
of KiwiTech, LLC, subject to important disclaimers and conditions including
restrictions on the use, disclosure, transfer or export of such
information.* *If you have received this message in error or are not the
named recipient(s), please immediately notify the sender at the telephone
number stated above or by reply e-mail and delete this e-mail from your
computer*

Browse pgsql-in-general by date

  From Date Subject
Next Message Nishtha Srivastava 2016-07-31 15:24:03 How to install postgresql-server-dev-9.4 from source code (postgresql-9.4.6.tar.gz) on Ubuntu 14
Previous Message Rich Compton 2016-06-02 18:43:27 Re: Aggregating data from stored procedures across multiple schemas