[GENERAL] help with a procedure

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 9:32 GMT-06:00 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 > (&#

Re: [GENERAL] help with a procedure

tanding how to call >> postgres from php. >> >> Regards >> Seref >> >> >> >> >> On Thu, Jun 5, 2014 at 5:03 PM, Carlos Carcamo >> wrote: >> >>> Thanks for answering... >>> I'm using php with postgresql 9.1, I hav

Re: [GENERAL] help with a procedure

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

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

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] execute trigger after another one

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 perfor

Re: [GENERAL] execute trigger after another one

2014-12-04 16:46 GMT-06:00 David G Johnston : > 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), but

Re: [GENERAL] execute trigger after another one

2014-12-04 17:31 GMT-06:00 Adrian Klaver : > On 12/04/2014 03:11 PM, Carlos Carcamo wrote: >> >> 2014-12-04 16:46 GMT-06:00 David G Johnston : >>> >>> Carlos Carcamo wrote >>>> >>>> I read about oGlenrder of execution of triggers, is supp