[GENERAL] execute trigger after another one

2014-12-04 Thread Carlos Carcamo
Hello list, hope you're well. I need some help with postgres. I have two triggers that are executed after insert, update and delete. One trigger is with plpgsql language and the other one is with pl/python, the first one just update some tables and last one calls a *.sh that is executed to

Re: [GENERAL] execute trigger after another one

2014-12-04 Thread Carlos Carcamo
2014-12-04 16:46 GMT-06:00 David G Johnston david.g.johns...@gmail.com: Carlos Carcamo wrote I read about order of execution of triggers, is supposed that postgres executes triggers in alphabetical order, so I called the plpgsql a_trigger and the second one b_trigger (as an example

Re: [GENERAL] execute trigger after another one

2014-12-04 Thread Carlos Carcamo
2014-12-04 17:31 GMT-06:00 Adrian Klaver adrian.kla...@aklaver.com: On 12/04/2014 03:11 PM, Carlos Carcamo wrote: 2014-12-04 16:46 GMT-06:00 David G Johnston david.g.johns...@gmail.com: Carlos Carcamo wrote I read about oGlenrder of execution of triggers, is supposed that postgres executes

[GENERAL] pg_dump: [archiver] -C and -c are incompatible options

2014-09-23 Thread Carlos Carcamo
Hello list, I need some help with this error: ... pg_dump: saving encoding = UTF8 pg_dump: saving standard_conforming_strings = on pg_dump: [archiver] -C and -c are incompatible options pg_dump: *** aborted because of error Process returned exit code 1. I get this error when i'm trying to create

[GENERAL] help with a procedure

2014-06-05 Thread Carlos Carcamo
Hi everyone, I wonder if you could help me with a procedure that I would like to perform in postgresql. I have an insert query like this: INSERT INTO products (product_id, description, price, qty, ...) values ('01', 'some description', 10.15, 5, ...) then if there is no problem, perform another

Re: [GENERAL] help with a procedure

2014-06-05 Thread Carlos Carcamo
2014-06-05 9:32 GMT-06:00 Carlos Carcamo eazyd...@gmail.com: Hi everyone, I wonder if you could help me with a procedure that I would like to perform in postgresql. I have an insert query like this: INSERT INTO products (product_id, description, price, qty, ...) values ('01', 'some

Re: [GENERAL] help with a procedure

2014-06-05 Thread Carlos Carcamo
, 2014 at 4:36 PM, Carlos Carcamo eazyd...@gmail.com wrote: 2014-06-05 9:32 GMT-06:00 Carlos Carcamo eazyd...@gmail.com: Hi everyone, I wonder if you could help me with a procedure that I would like to perform in postgresql. I have an insert query like this: INSERT INTO products

Re: [GENERAL] help with a procedure

2014-06-05 Thread Carlos Carcamo
Just a little, I will read it again, thanks for your help. 2014-06-05 10:39 GMT-06:00 David G Johnston david.g.johns...@gmail.com: Have you read this chapter of the documentation? http://www.postgresql.org/docs/9.3/interactive/plpgsql.html Carlos Carcamo wrote What I need is some help