Re: DBD::Pg (version 3.16.3) returns EMPTY char columns as 'undef'

2023-04-25 Thread Matthias Apitz
El día martes, abril 25, 2023 a las 09:58:10 +0900, Ian Lawrence Barwick escribió: > "eq undef" looks very wrong there: > > $ perl -e "printf(qq|%i\n|, '' eq undef);" > 1 > $ perl -e "printf(qq|%i\n|, defined '');" > 1 > > You probably want "if (!defined $row_ary[$i])". And poss

Re: FW: Error!

2023-04-25 Thread postgresql439848
Am 25.04.23 um 17:02 schrieb Adrian Klaver: On 4/25/23 07:31, postgresql439...@heinz-it.de wrote: Am 25.04.23 um 01:16 schrieb Arquimedes Aguirre: No, it has not changed the error that I have been experiencing since the beginning. This is the error: psql: error: connection to server at "loca

Re: DBD::Pg (version 3.16.3) returns EMPTY char columns as 'undef'

2023-04-25 Thread Peter J. Holzer
On 2023-04-25 14:41:45 +0200, Matthias Apitz wrote: > We're using the above DBD::Pg version on Linux together with PostgreSQL 15.1 > On fetch empty char columns are returned as (Perl) 'undef' > > while ( my @row_ary = $dba->FetchArray()) { What is FetchArray? Neither perldoc DBI

Re: VACUUM (INDEX_CLEANUP OFF) and GIN indexes

2023-04-25 Thread Christophe Pettus
> On Apr 25, 2023, at 09:35, Peter Geoghegan wrote: > > It's skipped by VACUUM, but not by ANALYZE. So if you're using the > reloption version of index_cleanup=off, it isn't necessarily going to > stop autovacuum/autoanalyze from doing pending list cleanup. Ugh, thanks. I wasn't aware that i

Re: VACUUM (INDEX_CLEANUP OFF) and GIN indexes

2023-04-25 Thread Peter Geoghegan
On Tue, Apr 25, 2023 at 9:18 AM Christophe Pettus wrote: > Does VACUUM (INDEX_CLEANUP OFF) flush the pending list for GIN indexes, or is > that skipped as well? It's skipped by VACUUM, but not by ANALYZE. So if you're using the reloption version of index_cleanup=off, it isn't necessarily going t

VACUUM (INDEX_CLEANUP OFF) and GIN indexes

2023-04-25 Thread Christophe Pettus
Does VACUUM (INDEX_CLEANUP OFF) flush the pending list for GIN indexes, or is that skipped as well?

Re: murmur3 hash binary data migration from Oracle to PostgreSQL

2023-04-25 Thread Imre Samu
> > No we want to generate murmur3 format only. > If you need a server-side murmur3 function - one alternative is the https://github.com/markokr/pghashlib extension. psql (15.2 (Debian 15.2-2)) Type "help" for help. db=# create extension hashlib; CREATE EXTENSION db=# select hash_string('', 'm

Re: FW: Error!

2023-04-25 Thread Adrian Klaver
On 4/25/23 07:31, postgresql439...@heinz-it.de wrote: Am 25.04.23 um 01:16 schrieb Arquimedes Aguirre: No, it has not changed the error that I have been experiencing since the beginning. This is the error: psql: error: connection to server at "localhost" (::1), port 5432 failed: FATAL: passwo

Re: FW: Error!

2023-04-25 Thread postgresql439848
Am 25.04.23 um 01:16 schrieb Arquimedes Aguirre: No, it has not changed the error that I have been experiencing since the beginning. This is the error: psql: error: connection to server at "localhost" (::1), port 5432 failed: FATAL: password authentication failed for user "punta" Press any ke

Re: DBD::Pg (version 3.16.3) returns EMPTY char columns as 'undef'

2023-04-25 Thread Ian Lawrence Barwick
2023年4月25日(火) 21:42 Matthias Apitz : > > > Hello, > > We're using the above DBD::Pg version on Linux together with PostgreSQL 15.1 > On fetch empty char columns are returned as (Perl) 'undef' > > while ( my @row_ary = $dba->FetchArray()) { >foreach my $i (0

Re: psql:t_mstr.sql:994: ERROR: function to_char(numeric) does not exist

2023-04-25 Thread Erik Wienhold
> On 25/04/2023 13:34 CEST gzh wrote: > > >The solution is the same whether you upgrade or not: you need > >to adjust your search_path to include the "oracle" schema, > >or else explicitly qualify references to orafce functions. > Thank you very much for your help. > > To use the to_date functions

DBD::Pg (version 3.16.3) returns EMPTY char columns as 'undef'

2023-04-25 Thread Matthias Apitz
Hello, We're using the above DBD::Pg version on Linux together with PostgreSQL 15.1 On fetch empty char columns are returned as (Perl) 'undef' while ( my @row_ary = $dba->FetchArray()) { foreach my $i (0..$#row_ary) { if (

Re: psql:t_mstr.sql:994: ERROR: function to_char(numeric) does not exist

2023-04-25 Thread gzh
>The solution is the same whether you upgrade or not: you need >to adjust your search_path to include the "oracle" schema, >or else explicitly qualify references to orafce functions.Thank you very much >for your help. To use the to_date functions of Orafce 3.0.1, we created the following to_date

Re: murmur3 hash binary data migration from Oracle to PostgreSQL

2023-04-25 Thread Erik Wienhold
> On 25/04/2023 12:44 CEST Jagmohan Kaintura wrote: > > No we want to generate murmur3 format only. > > > On 25-Apr-2023, at 8:52 AM, Jeffrey Walton wrote: > > > > My apologies if I misparsed a couple of statements. I am having > > trouble determining if you are migrating away from Murmur3. > > >