On 12/12/23 16:09, Igniris Valdivia Baez wrote:
Hello to all, to clarify the data is moving this way:
1. The data is extracted from a database in postgres using Pentaho(Kettle)
2. Here is there is a bifurcation some data is loaded into the destiny
database and behaves fine the other scenario
Hello to all, to clarify the data is moving this way:
1. The data is extracted from a database in postgres using Pentaho(Kettle)
2. Here is there is a bifurcation some data is loaded into the destiny
database and behaves fine the other scenario the data is saved in xls files
to be reviewed
3.
On 12/12/23 15:54, Igniris Valdivia Baez wrote:
Please use Reply All to reply to list also
Ccing list
PgAdmin 4 but it looks the same in the console and from postman.
I believe that the problem is the xls that is generated from a postgres
database opened in Windows to fulfill a review
On 12/11/23 10:54, Igniris Valdivia Baez wrote:
hello to all, thanks for your answers i've changed the encoding using this:
ALTER DATABASE testdb
SET client_encoding = WIN1252;
now when we try to select data from a table we get this error:
ERROR: character with byte sequence 0xe2 0x80 0x8b in
On 12/12/23 12:44, Igniris Valdivia Baez wrote:
this is the result I got, now I have to figure it out how to solve it,
thank you so much
In what client are you viewing the data?
--
Adrian Klaver
adrian.kla...@aklaver.com
On Tue, 2023-12-12 at 15:44 -0500, Igniris Valdivia Baez wrote:
> this is the result I got, now I have to figure it out how to solve it,
Since you already have a replacement character in the database, the
software that stores the data in the database must be responsible.
PostgreSQL doesn't
On Tue, Dec 12, 2023 at 3:13 PM Marcos Pegoraro wrote:
> My functions should return varchar(5) or should return an exception, but
> sometimes they return CHARACTER VARYING. Why ?
>
> thanks for any explanation
>
The observed behavior is documented.
My functions should return varchar(5) or should return an exception, but
sometimes they return CHARACTER VARYING. Why ?
create or replace function f_sql() returns varchar(5) language sql as
$$select '0123456789'$$;
--works, but shouldn't
select * from f_sql();
create domain T5 as varchar(5);
this is the result I got, now I have to figure it out how to solve it,
thank you so much
El mar, 12 dic 2023 a las 14:42, Daniel Verite
() escribió:
>
> Igniris Valdivia Baez wrote:
>
> > hello, thank you for answering, it's not a typo, in the attachments
> > you can see that this is
Igniris Valdivia Baez wrote:
> hello, thank you for answering, it's not a typo, in the attachments
> you can see that this is actually my collation, algo a pic of the
> problem for more clarification,
This character is meant to replace undisplayable characters:
From
Hi all,
@Ron Johnson, I am building from the source because I wanted to contribute
to the open-source community, and for that, I want the source files. I had
a few things in mind currently for the same :).
@Tom Lane , Thanks I am using a directory path with
spaces in it, and removing them solved
Ayush Vatsa writes:
> Sorry, I should have included the required information initially itself. I
> am new to the database field so please pardon my mistakes :)
You still didn't mention the platform/environment, but I guess from
the reference to -isysroot that it must be macOS (Darwin). I
On Tue, Dec 12, 2023 at 11:02 AM Ayush Vatsa
wrote:
> Hi,
> Sorry, I should have included the required information initially itself. I
> am new to the database field so please pardon my mistakes
>
Why are you building from source instead of using a packaged solution?
Hi,
Sorry, I should have included the required information initially itself. I
am new to the database field so please pardon my mistakes :)
What I have done till now is clone the source code files from Gihub in my
Mac laptop and then try to follow this documentation
On Mon, 2023-12-11 at 13:54 -0500, Igniris Valdivia Baez wrote:
> El sáb, 9 dic 2023 a las 1:01, Laurenz Albe ()
> escribió:
> >
> > On Fri, 2023-12-08 at 23:58 -0500, Igniris Valdivia Baez wrote:
> > > hello, I have an ETL process collecting data from a postgresql
> > > database and xls files
15 matches
Mail list logo