Re: When use triggers?

2018-05-17 Thread Tim Cross
hmidi slim writes: > HI, > > I'm working on a microservice application and I avoid using triggers > because they will not be easy to maintain and need an experimented person > in database administration to manage them. So I prefer to manage the work > in the application

Re: Problem compiling PostgreSQL.

2018-05-17 Thread Daniel Verite
Paul Linehan wrote: > Now, I've installed the icu libraries using the classic ./configure, make > and sudo make install. So it got installed under /usr/local > collationcmds.c:(.text+0xe36): undefined reference to `uloc_getAvailable_61' > collationcmds.c:(.text+0xe5b): undefined

Re: Problem compiling PostgreSQL.

2018-05-17 Thread Paul Linehan
Hi again, As a followup - I ran this command (do I need to set LD_LIBRARY_PATH?) [pol@polhost /]$ sudo find . -name "icu*" | grep -v Downloads | more And got: ./usr/local/sbin/icupkg ./usr/local/bin/icuinfo ./usr/local/bin/icu-config ./usr/local/lib/icu ./usr/local/lib/pkgconfig/icu-io.pc

Re: Problem compiling PostgreSQL.

2018-05-17 Thread Paul Linehan
>> On which platform and/or distribution are you trying the code >> compilation? > sorry about that - it's Linux Fedora 28, 64 bit Intel X86_64 - Samsung > laptop, 8GB RAM, quad-core. PostgreSQL 10.4 also. Pól...

Re: Problem compiling PostgreSQL.

2018-05-17 Thread Paul Linehan
Hi, and thanks for responding, >> I'm having problems compiling PostgreSQL. > On which platform and/or distribution are you trying the code > compilation? Ooops! sorry about that - it's Linux Fedora 28, 64 bit Intel X86_64 - Samsung laptop, 8GB RAM, quad-core. Please don't hesitate to ask

Re: Problem compiling PostgreSQL.

2018-05-17 Thread Michael Paquier
On Thu, May 17, 2018 at 08:31:48AM +0100, Paul Linehan wrote: > I'm having problems compiling PostgreSQL. On which platform and/or distribution are you trying the code compilation? -- Michael signature.asc Description: PGP signature

Problem compiling PostgreSQL.

2018-05-17 Thread Paul Linehan
Hi all, I'm having problems compiling PostgreSQL. I can run "make" no problem with this command ./configure --prefix=/home/pol/Downloads/sware/db/pg/inst --mandir=/home/pol/Downloads/sware/db/pg/inst/man --docdir=/home/pol/Downloads/sware/db/pg/inst/doc --enable-nls --with-python --with-openssl

PostgreSQL : encryption with pgcrypto

2018-05-17 Thread ROS Didier
Hi Regarding the encryption of data by pgcrypto, I would like to know the recommendations for the management of the key. Is it possible to store it off the PostgreSQL server? Is there the equivalent of Oracle "wallet" ? Thanks in