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*
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 |