Re: When use triggers?

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

Re: When use triggers?

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

Re: When use triggers?

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

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

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

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

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.