Re: Empty to NULL conversion - Ruby - Postgres ?

From: Jeff Davis <pgsql(at)j-davis(dot)com>
To: Venks <venkatesh(dot)mantha(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Empty to NULL conversion - Ruby - Postgres ?
Date: 2008-02-05 22:47:01
Message-ID: 1202251621.24634.54.camel@dogma.ljc.laika.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, 2008-02-01 at 20:33 -0500, Venks wrote:
> Hi,
>
> I am trying to copy some data from MySQL to Postgres using Ruby. This
> is NOT a MySQL to PostgreSQL conversion project. I need to read the
> data from a MySQL database and load it into PostgreSQL database.
>
> How do I handle "nil" in ruby and convert them into NULL so that I can
> insert NULL into INT columns instead of empty values? In short I am
> getting the following popular error:
>

Can you install the latest module from the ruby-pg project (or just "gem
install pg").

If you have this problem still, send an email to the ruby-pg-general
mailing list (or post in the forum, or email me directly).

Regards,
Jeff Davis

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message johnf 2008-02-06 00:10:41 Does has_table_privilege() have a case bug
Previous Message Jeff Davis 2008-02-05 22:28:00 Re: Out of Memory errors while running pg_dump