From: | "c k" <shreeseva(dot)learning(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org, pgsql-admin(at)postgresql(dot)org |
Subject: | Functions |
Date: | 2008-09-15 16:55:38 |
Message-ID: | d8e7a1e30809150955v32f01897wa900261ac86af34b@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin pgsql-general |
Dear PG members,I want to know that does begin and end in plpgsql are
related to begin transactions and commit? if yes/no how? If I start to
execute a function of multiple statements does PG commits each transaction
within a function, or whole function as a transaction.
Also if first statement makes inserts/updates a row, does it automatically
available to that particular function execution only or to any other
instances of same function?
Please give the details.
In my system, function are extensively used and cab called by different
clients as ODBC, JDBC and others.
Thanks for help,
CPK
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2008-09-15 17:08:08 | Re: Trouble setting up access privileges |
Previous Message | Joshua Drake | 2008-09-15 16:27:02 | Re: ERROR: could not open relation 16388/24734/51896: Cannot open or remove a file containing a running program. |
From | Date | Subject | |
---|---|---|---|
Next Message | David Fetter | 2008-09-15 17:06:08 | Re: Oracle and Postgresql |
Previous Message | Gregory Stark | 2008-09-15 16:53:16 | Re: Oracle and Postgresql |