Problem dbi_link with postgresql 9.04

From: Emanuel Araújo <eacshm(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Problem dbi_link with postgresql 9.04
Date: 2011-09-21 10:38:14
Message-ID: CAMuTAkZscSkpBEAEm-ZBCs_-BZ1X-=OnR+8VHUtePsQUAKH=aA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

In one of our applications, we use the dbi_link for communication with a
firebird db, works very well in version 8.3 we have one of our PostgreSQL
server (CentOS 5.3). We are doing tests for migration to version 9.4
or 9.1, and
the use of tests dbi_link got the following errors:

dbi_fortes = # SELECT "NAME" FROM ag. "CLI";
WARNING: SELECT dbi_link.cache_connection (1) at line 12.
CONTEXT: PL / Perl function "remote_select"
ERROR: invalid byte sequence for encoding "LATIN1": 0x00 at line 198.
CONTEXT: PL / Perl function "remote_select"

Originally the db was SQL_ASCII but was migrated to use LATIN1, and the same
problem occurs when using the original encoding (SQL_ASCII).

Using the query to collect just one of the linked table fields, "dbi_fortes =
# SELECT * FROM dbi_link.remote_select (1, 'SELECT NAME FROM CLI':: text)
remote_select (" NAME "text) LIMIT 10;" it returns without no problem.

We think the field of this table that is causing the error, and it
contains NULL
values.

Using "isql" I can usually return the data.

questions:

1. which may have changed from version 8.3/8.4 (works well) to version
9.* which
can cause this kind of incompatibility?

2. does anyone know of any bug dbi_link about it?

3. Is there any other tool similar to dbi_link use?

4. Something else that can help me about it?

Thanks.
Digite um texto ou endereço de um site ou traduza um
documento.<http://translate.google.com.br/?tr=f&hl=pt-BR>
Cancelar <http://translate.google.com.br/?tr=t&hl=pt-BR>
Tradução do português para inglês

--
*Atenciosamente,

Emanuel Araújo*
http://eacshm.wordpress.com/
*
*
*Linux Certified
LPIC-1*

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Szymon Guz 2011-09-21 10:43:30 Re: Random multiple times
Previous Message c k 2011-09-21 10:17:54 Re: problem connecting postgresql 9.0 tables from vba