Re: Problem dbi_link with postgresql 9.04

From: "Albe Laurenz" <laurenz(dot)albe(at)wien(dot)gv(dot)at>
To: Emanuel Araújo *EXTERN* <eacshm(at)gmail(dot)com>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: Problem dbi_link with postgresql 9.04
Date: 2011-09-30 12:10:35
Message-ID: D960CB61B694CF459DCFB4B0128514C206F084B7@exadv11.host.magwien.gv.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Emanuel Araújo wrote:
> found that the problem occurs when the dbi_link makes parsing of a field float / double to a text
> field, because when it creates the tables already created with this type of data.

I do not understand that.

> Another thing we see is that the problem is not with null fields or zero bytes but with a value of
> 1.5, no problem in NULLs or Zero Bytes.
>
> Based on that there is any solution?

What I would do is check how the data look in Perl.
Build a simple Perl script that selects the problem data and display them byte for byte.

That should help understand the problem.

Yours,
Laurenz Albe

In response to

Browse pgsql-general by date

  From Date Subject
Next Message hamann.w 2011-09-30 12:22:27 how to improve this similarity query?
Previous Message Emanuel Araújo 2011-09-30 11:42:20 Re: Problem dbi_link with postgresql 9.04