Re: PL/java

2020-12-08 Thread Zé Rui Marques
Hi, My concern is a purely commercial, in this case. We work only for “large” companies. Only telecommunications operators (more than 5 million subscribers) In this environment the “IBM / SAP / Accenture” effect is very strong - “I chose the leader, it is not my fault that it failed” So,

Re: postgres-10 with FIPS

2020-12-08 Thread Aravindhan Krishnan
Hi Folks, Thanks for the responses. Since the underlying knob flip is a paid version and we are a SaaS based service provider, this might not align well with our requirement and so wanted to build postgres-10 against FIPS compliant ssl/crypto. The "pg_config" is of of great help in order to

Re: JDBC driver - is "getGeneratedKeys()" guaranteed to return the ids in the same order a batch insert was made?

2020-12-08 Thread Dave Cramer
On Sun, 6 Dec 2020 at 15:52, electrotype wrote: > Hi, > > Using JDBC, I batch insert multiple rows (*"executeBatch()*"). I then use > *'**getGeneratedKeys("id")*' to get the generated ids ("id" is a "*SERIAL > PRIMARY KEY*" column). > > My question: does the PostgreSQL JDBC driver *guarantees

Re: Potential BRIN Index Corruption

2020-12-08 Thread Huan Ruan
HI Alvaro Unfortunately those records were written a while ago and we no longer keep their WAL logs. Thanks for your help anyway. Huan On Fri, 27 Nov 2020 at 08:40, Huan Ruan wrote: > Thanks Alvaro for pointing me to pageinspect. I will give it a try and >> report back. It might take a few

Re: postgres-10 with FIPS

2020-12-08 Thread Tom Lane
Aravindhan Krishnan writes: > * Would it be possible to share the configure command used in building the > standard postgres package ? There is no "the standard" postgres package. There's a different one for every major platform or distro, and in some cases more than one available from

Re: simple reporting tools for postgres in aws

2020-12-08 Thread Alexandre Arruda
Em seg., 7 de dez. de 2020 às 12:53, Chris Stephens escreveu: > Hello, > > We have a need to display some very simple reports generated from views in > an rds postgres database. We need little more functionality beyond simple > filtering, column hiding, sorting, grouping. Anything much beyond

Re: PL/java

2020-12-08 Thread Thomas Kellerer
Rob Sargent schrieb am 07.12.2020 um 23:22: > If I'm tracking correctly I can say the java implementation of > CopyManager is, to me, blindingly fast. So if the E and the T are in > java then certainly the L can be also. I can confirm that using CopyManager in JDBC has pretty much the same

Re: PL/java

2020-12-08 Thread David Goodenough
As of Java-16 there is a replacement for JNI which allows direct calling of native interfaces without the need for hand coded stub code. On Monday, 7 December 2020 22:10:01 GMT Martin Gainty wrote: > Nota Bene: > Almost all official interfaces to/from Oracle are coded in Java > FWIK google's

Re: postgres-10 with FIPS

2020-12-08 Thread Aravindhan Krishnan
Hi Community, Can someone help me on the above request ? * Would it be possible to share the configure command used in building the standard postgres package ? * We would like to build a debian package post the make -- would checkinstall be the right tool for this purpose ? Regards, Aravindhan