Re: When use triggers?

2018-05-18 Thread Berend Tober
Michael Stephenson wrote: On Wed, May 16, 2018 at 6:36 PM, Adrian Klaver wrote: On 05/16/2018 03:19 PM, hmidi slim wrote: 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 administrat

Re: When use triggers?

2018-05-18 Thread Ken Tanzer
On Fri, May 18, 2018 at 12:45 PM, Melvin Davidson wrote: > > > > I have used triggers to keep audit-logs of changes to certain columns in > a table > Another good use for triggers is to maintain customer balance..EG: An > INSERT, UPDATE or DELETE involving a customer payment > (or in the case of

Re: When use triggers?

2018-05-18 Thread Melvin Davidson
On Fri, May 18, 2018 at 9:35 AM, Vick Khera wrote: > On Wed, May 16, 2018 at 6:19 PM, hmidi slim wrote: > >> 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 t

Re: When use triggers?

2018-05-18 Thread Vick Khera
On Wed, May 16, 2018 at 6:19 PM, hmidi slim wrote: > 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 applic

Re: Out of memory error with PG10.3, 10.4 but not 9.3.19

2018-05-18 Thread Peter J. Holzer
On 2018-05-15 15:02:48 +, ChatPristi wrote: > I have a SELECT command (in partitionned tables) that failed with: > psql:/tmp/query.txt:1: ERROR: out of memory > DETAIL: Cannot enlarge string buffer containing 1073741818 bytes by 32 more > bytes. 1073741818 is a bit less than 1GB and 10737418

Re: Importing data from CSV into a table with array and composite types

2018-05-18 Thread Pavel Stehule
Hi 2018-05-18 10:37 GMT+02:00 a <372660...@qq.com>: > Hi: > > I would like to import data from a csv table. But the table that is going > to be inserted is constructed with arrays and composite types, also with > array of composite. > > I have tried many ways of inserting but fail. Can anyone hel

Importing data from CSV into a table with array and composite types

2018-05-18 Thread a
Hi: I would like to import data from a csv table. But the table that is going to be inserted is constructed with arrays and composite types, also with array of composite. I have tried many ways of inserting but fail. Can anyone help? Thank you so much.