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 with the procedure in postgres, I have searched > in > google, but I dont know how to do it, the goal is perform the first insert > and then the second insert if the first one succeed in one procedure > instead of using two separate inserts. > > Do you have some code like that? > > 2014-06-05 10:14 GMT-06:00 Seref Arikan < > serefarikan@ > >: > >> Sorry, I meant: "calling a stored procedure you'll write in postgres from >> php" >> >> >> On Thu, Jun 5, 2014 at 5:13 PM, Seref Arikan < > serefarikan@ > > >> wrote: >> >>> Hi Carlos, >>> When you say procedures, do you mean calling a stored procedure you'll >>> write from php? Or executing the individual INSERT from php >>> sequentially? >>> For the first scenario, you'd need to write a postgresql stored >>> procedure >>> (I suggest you google: PL/pgSQL tutorial) and call the from php. For the >>> second, well, it is exactly what I said before: you'll need to open a >>> connection to postgres, execute your statements under a transaction and >>> commit. I'd suggest you either search for php and postgres or ask this >>> to a >>> php mail group. Your goal here appears to be understanding how to call >>> postgres from php. >>> >>> Regards >>> Seref >>> >>> >>> >>> >>> On Thu, Jun 5, 2014 at 5:03 PM, Carlos Carcamo < > eazyduiz@ > > >>> wrote: >>> >>>> Thanks for answering... >>>> I'm using php with postgresql 9.1, I have never used procedures with >>>> php, I'm new with postgresql >>>> >>>> >>>> 2014-06-05 9:45 GMT-06:00 Seref Arikan < > serefarikan@ > >: >>>> >>>> Hi Carlos, >>>>> Unless I'm missing something here, your queries are probably being >>>>> called from a programming language (java/c# etc) and your database >>>>> access >>>>> api should support transactions. If you perform both operations under >>>>> the >>>>> same db transaction and commit your transaction things should be fine. >>>>> If >>>>> there is a problem with the first INSERT, your api should throw an >>>>> exception and you won't be able to commit the transaction (you may/may >>>>> not >>>>> need to call rollback in your catch block), so it'll either be both >>>>> calls >>>>> executed or none. >>>>> >>>>> You may want to read about how db transactions are handled in your >>>>> programming environment. >>>>> >>>>> Regards >>>>> Seref >>>>> >>>>> >>>>> >>>>> On Thu, Jun 5, 2014 at 4:36 PM, Carlos Carcamo < > eazyduiz@ > > >>>>> wrote: >>>>> >>>>>> >>>>>> 2014-06-05 9:32 GMT-06:00 Carlos Carcamo < > eazyduiz@ > >: >>>>>> >>>>>> 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 query like: >>>>>>> >>>>>>> INSERT INTO store(store_id, description, price, qty, ...) values >>>>>>> ('02', 'some description', 10.15, 5, ...) >>>>>>> >>>>>>> So the second query depends of the first query, if the first one >>>>>>> succeed the second will perform the second insert >>>>>>> >>>>>>> I would like to do something like: >>>>>>> >>>>>>> SELECT myProcedure(product_id, p_description, price, qty, store_id, >>>>>>> store_description ); >>>>>>> >>>>>>> waiting for a response from procedure, maybe true or false. >>>>>>> >>>>>>> Thanks in advance... >>>>>>> >>>>>>> >>>>>>> >>>>>>> -- >>>>>>> "El desarrollo no es material es un estado de conciencia metal" >>>>>>> >>>>>> >>>>>> Sorry, the second query looks like: >>>>>> INSERT INTO store(store_id, description, product_id, price, qty, ...) >>>>>> values ('02', 'some description', '01', 10.15, 5, ...) >>>>>> >>>>>> -- >>>>>> "El desarrollo no es material es un estado de conciencia metal" >>>>>> >>>>> >>>>> >>>> >>>> >>>> -- >>>> "El desarrollo no es material es un estado de conciencia metal" >>>> >>> >>> >> > > > -- > "El desarrollo no es material es un estado de conciencia metal" -- View this message in context: http://postgresql.1045698.n5.nabble.com/help-with-a-procedure-tp5806213p5806230.html Sent from the PostgreSQL - general mailing list archive at Nabble.com.
