PostgreSQL and Flashback Database

Hi My company is looking for a team of developers to implement the "flashback database" functionality in PostgreSQL. Do you think it's feasible to implement? how many days of development? Thanks in advance Best Regards Didier ROS E.D.F

Migration Oracle multitenant database to PostgreSQL ?

Hi I would like to know if it is possible to migrate Oracle multitenant database (with multiple PDB) to PostgreSQL ? Thanks in advance Best Regards D ROS EDF Ce message et toutes les pièces jointes (ci-après le 'Message') sont établis à l'intention exclusive des destinataires et les

RE: PostgreSQL and big data - FDW

Hi Stephen My EDF company is very interested in this feature (KERBEROS authentication method and hdfs_fdw ). Is it possible to know how many days of development does this represent ? who can develop this implementation ? what cost ? Best Regards Didier ROS EDF -Message d'origine---

RE: PostgreSQL and big data - FDW

re of that ? Could EDB make a clear statement on this point? If so, how to implement this method ? is there any document on this subject ? Thanks in advance. Best Regards Didier ROS didier@edf.fr Tél. : +33 6 49 51 11 88 -Message d'origine- De : br...@momjian.us [mailto:b

PostgreSQL and big data - FDW

Hi I would like to use a Foreign Data Wrapper (FDW) to connect to a HADOOP cluster which uses KERBEROS authentication. is it possible to achieve this ? which FDW should be used ? Thanks in advance Best Regards Didier ROS EDF Ce message et toutes les pièces jointes (ci-après le 'Me

open-source equivalent of golden-gate

pen-source product. Thanks in advance Best Regards Didier ROS EDF Ce message et toutes les pièces jointes (ci-après le 'Message') sont établis à l'intention exclusive des destinataires et les informations qui y figurent sont strictement confidentielles. Toute utilisation de ce

RE: problem with read-only user

will not have the rights to read them. Kidsdpn03_ro must be explicitly granted read rights on this objects. Can you confirm that if it was the kidsdpn03_ro role that created the tables, there would be no problem when accessing new tables? Thanks in advance. Didier ROS didier@e

problem with read-only user

ose new tables. Anybody can help to solve this problem ? Thank you in advance Didier ROS didier@edf.fr Ce message et toutes les pièces jointes (ci-après le 'Message') sont établis à l'intention exclusive des destinataires et les informations qui y figurent sont stri

RE: get_database_name() from background worker

Hi With pg_background extension ,it is possible to make "autonomous transaction" which means possibility to commit in a transaction. It is like a client which connects to a postgresql instance. So you can execute any sql orders . Best Regards Didier ROS -Message d'

RE: get_database_name() from background worker

So, What are you using to create background workers ? Can you show me an extract of your code ? TIA Best Regards Didier De : koi...@2ndquadrant.com [mailto:koi...@2ndquadrant.com] Envoyé : mercredi 11 décembre 2019 09:16 À : ROS Didier Cc : tsunakawa.ta...@fujitsu.com; pgsql-hackers

RE: get_database_name() from background worker

Hi I would like to know : Are you using pg_background extension to work with backgroud workers ? Thanks in advance Best Regards Didier ROS Expertise SGBD EDF - DTEO - DSIT - IT DMA -Message d'origine- De : tsunakawa.ta...@fujitsu.com [mailto:tsunaka

Re: Unsigned 64 bit integer to numeric

Hi, I don't think so, but there's an (unmaintained?) uint extension at https://github.com/petere/pguint.git On Wed, Dec 4, 2019 at 11:24 AM Dmitry Dolgov <9erthali...@gmail.com> wrote: > Hi, > > Probably a simple question, but I don't see a simple answer so far. In > one extension I want to con

Re: [PATCH] gcc warning 'expression which evaluates to zero treated as a null pointer'

Hi, On Wed, Nov 13, 2019 at 10:01 PM Tom Lane wrote: > > didier writes: > > clang -E output before 7a0574b5 > > HeapTuple newtuple = 0; > > with 7a0574b5 > > HeapTuple newtuple = ((bool) 0); > > Hm, did you re-run configure after 7a0574b5? If you didn

Re: [PATCH] gcc warning 'expression which evaluates to zero treated as a null pointer'

Hi, On Wed, Nov 13, 2019 at 8:52 PM Tom Lane wrote: > > didier writes: > > Trivial patch: > > - remove a gcc warning (since commit 7a0574b5) > > expression which evaluates to zero treated as a null pointer constant of > > type 'HeapTuple' (ak

[PATCH] gcc warning 'expression which evaluates to zero treated as a null pointer'

Hi, Trivial patch: - remove a gcc warning (since commit 7a0574b5) expression which evaluates to zero treated as a null pointer constant of type 'HeapTuple' (aka 'struct HeapTupleData *') - always use "if (newtuple == NULL)" rather than mixing !newtuple and ne

PostgreSQL and Real Application Testing (RAT)

version, the creation of an index.. is there an equivalent in the PostgreSQL community? if not, do you think it's technically possible to do it ? who would be interested in this project ? Thanks in advance Best Regards Didier ROS EDF Ce message et toutes les pièces jointes (ci-après le &#x

PostgreSQL and TLS 1.2

Hi I would like to check that postgresql is compatible with TLS 1.2. what test could I do to check this compatibility? Thanks in advance Best Regards Didier ROS EDF Ce message et toutes les pièces jointes (ci-après le 'Message') sont établis à l'intention exclusive des d

Custom Scan coverage.

such test suite. Regards Didier.

contrib make check-world fail if data have been modified and there's vpath

Hi, because there's destination data src/makefiles/pgxs.mk line ln -s $< $@ fails and make clean doesn't remove these links. ln -sf is an option but it's not tested in configure or rm -f Regards Didier

Re: Fix runtime errors from -fsanitize=undefined

no idea if it's relevant. Regards Didier On Thu, Jun 6, 2019 at 11:36 AM Peter Eisentraut wrote: > > On 2019-06-05 21:30, Robert Haas wrote: > > On Mon, Jun 3, 2019 at 3:22 PM Peter Eisentraut > > wrote: > >> After many years of trying, it seems the -fsanitiz

Re: PG 11 JIT deform failure

../contrib/tablefunc/tablefunc.c is wrong it's the fourth column. Regards Didier On Thu, Jun 13, 2019 at 8:35 PM Andres Freund wrote: > > Hi, > > On June 13, 2019 11:08:15 AM PDT, didier wrote: > >Extensions can do it, timescaledb in this case with: > >INSERT INTO ... RET

Re: Generating partitioning tuple conversion maps faster

Hi, Any chance for a backport to PG 11? cherry-pick apply cleanly and with a 100 columns table it improves performance nicely (20%). Regards Didier On Sat, Jul 14, 2018 at 1:25 AM David Rowley wrote: > > On 14 July 2018 at 04:57, Heikki Linnakangas wrote: > > Pushed, thanks! &g

Re: PG 11 JIT deform failure

Extensions can do it, timescaledb in this case with: INSERT INTO ... RETURNING *; Or replacing the test in llvm_compile_expr with an Assert in slot_compile_deform ?

Re: LLVM compile failing in seawasp

c.h defines a C Min macro conflicting with llvm new class llvm:ElementCount Min member On Thu, Jun 6, 2019 at 7:32 PM Alvaro Herrera wrote: > > Seawasp (using experimental clang 9.0) has been complaining of late: > > /home/fabien/clgtk/bin/clang -Wno-ignored-attributes -fno-strict-aliasing > -fw

PG 11 JIT deform failure

Hi, JIT slot_compile_deform assumes there's at least 'natts' in TupleDesc, eg /* * Iterate over each attribute that needs to be deformed, build code to * deform it. */ for (attnum = 0; attnum < natts; attnum++) { Form_pg_attribute

Re: [HACKERS] Small fix: avoid passing null pointers to memcpy()

iler choose to use sse instructions with 16 bytes requirement then compiler may not emit the right code. It's not rhetorical, big surprise first time you get a SIGBUS signal, or a SIGFPE doing integer math, on x64. Regards Didier

Re: [HACKERS] Small fix: avoid passing null pointers to memcpy()

Hi, On Fri, May 24, 2019 at 5:10 PM Tom Lane wrote: > > didier writes: > > A smaller version removing memset in print_aligned_text function. > > The line is redundant , header_done isn't used yet and it's either > > pg_malloc0 or null. > > Hm, I see t

Re: [HACKERS] Small fix: avoid passing null pointers to memcpy()

Hi A smaller version removing memset in print_aligned_text function. The line is redundant , header_done isn't used yet and it's either pg_malloc0 or null. Without this patch make check fails 3 tests if pg is compiled with -fsanitize=address,undefined diff --git a/src/fe_utils/print.c b/src/fe_uti

Re: [proposal] Add an option for returning SQLSTATE in psql error message

On Sat, Jan 5, 2019 at 6:30 PM Tom Lane wrote: > Peter Eisentraut writes: > > Why are you not including a test for \set VERBOSITY verbose? > > Stability of the output would be a problem ... > > Yes it could moreover the functionality wasn't tested before. Should I add one ?

Re: [proposal] Add an option for returning SQLSTATE in psql error message

On Mon, Dec 3, 2018 at 7:02 PM Pavel Stehule wrote: > It can works :). Please, assign it to next commitfest. Ok From e6d0261156838b07a5a25332fa0121d6d5c5 Mon Sep 17 00:00:00 2001 From: didier Date: Mon, 3 Dec 2018 19:20:54 +0100 Subject: [PATCH] Add sqlstate output mode to VERBOS

Re: [proposal] Add an option for returning SQLSTATE in psql error message

On Mon, Dec 3, 2018 at 5:51 PM Tom Lane wrote: > No, it's in libpq, so you'd have to touch that not the server. libpq, not as bad as the server but nonetheless maybe a bit too much for this. Is adding value in library contract? Anyway. attached a POC adding a new value to VERBOSITY (hopefully no

Re: [proposal] Add an option for returning SQLSTATE in psql error message

h LAST_ERROR_MESSAGE On Mon, Dec 3, 2018 at 4:49 PM Andrew Gierth wrote: > > >>>>> "didier" == didier writes: > > didier> Attached a POC adding a new variable ECHO_ERROR > didier> \set ECHO_ERROR text|none|psqlstate > > I wouldn't

Re: [proposal] Add an option for returning SQLSTATE in psql error message

Attached a POC adding a new variable ECHO_ERROR \set ECHO_ERROR text|none|psqlstate On Mon, Dec 3, 2018 at 2:47 AM Andrew Gierth wrote: > > > "Tom" == Tom Lane writes: > > Tom> I don't buy that argument. We use psql's normal display in all the > Tom> regular regression tests, and it's not

Re: [proposal] Add an option for returning SQLSTATE in psql error message

ression on pdsl variable. On Sun, Dec 2, 2018 at 5:05 PM Pavel Stehule wrote: > > > > ne 2. 12. 2018 v 16:56 odesílatel Tom Lane napsal: >> >> didier writes: >> > Currently on error psql is printing Postgres' PQerrorMessage text, but >> > the

[proposal] Add an option for returning SQLSTATE in psql error message

Hi, Currently on error psql is printing Postgres' PQerrorMessage text, but there's no guarantee these messages are constant between Postgres versions and it's a pain when using psql for writing regression tests, Prior Disallow setting client_min_messages higher than ERROR. a bad workaround was

RE: impact of SPECTRE and MELTDOWN patches

Hi No, 80% of our IT infrastructure is INTEL HW. Have you any recommendations to correct the impact on the performance ? Best Regards [cid:image002.png@01D14E0E.8515EB90] Didier ROS Expertise SGBD DS IT/IT DMA/Solutions Groupe EDF/Expertise Applicative - SGBD Nanterre Picasso - E2 565D (aile

RE: impact of SPECTRE and MELTDOWN patches

107727545 Swap: 2047 1071940 [root@pcyyymm9 ~]# uname -a Linux pcyyymm9.pcy.edfgdf.fr 3.10.0-862.6.3.el7.x86_64 #1 SMP Fri Jun 15 17:57:37 EDT 2018 x86_64 x86_64 x86_64 GNU/Linux Best regards [cid:image002.png@01D14E0E.8515EB90] Didier ROS Expertise SGBD DS IT/IT

impact of SPECTRE and MELTDOWN patches

of ~25%... Do you have such a result ? Thanks in advance. Best Regards [cid:image002.png@01D14E0E.8515EB90] Didier ROS Expertise SGBD DS IT/IT DMA/Solutions Groupe EDF/Expertise Applicative - SGBD Nanterre Picasso - E2 565D (aile nord-est) 32 Avenue Pablo Picasso 92000 Nanterre

How to use public key file to encrypt data

Hi I Would like to know how to encrypt data with physical public key files. I can't find any documentation about this subject. Thanks in advance Best Regards [cid:image002.png@01D14E0E.8515EB90] Didier ROS Expertise SGBD DS IT/IT DMA/Solutions Group

RE: Bulk Insert into PostgreSQL

COPY command. NB : autonomous transaction can commit It would normally divide the duration of the import by the number of CPUs. Best Regards [cid:image002.png@01D14E0E.8515EB90] Didier ROS Expertise SGBD DS IT/IT DMA/Solutions Groupe EDF/Expertise Applicative

unsubscribe pgsql-hack...@postgresql.org

[cid:image001.png@01D3608D.8F5DC9E0] Didier ROS DSP/CSP IT-DMA/Solutions Groupe EDF/Expertise Applicative Expertise SGBD 32 Avenue Pablo Picasso 92000 NANTERRE Ce message et toutes les pièces jointes (ci-après le 'Message') sont établis à l'intention exclusive des desti