Re: BUG #3376: Erro : COMMIT

From: Heikki Linnakangas <heikki(at)enterprisedb(dot)com>
To: Felipe Nogueira <fbnogueira(at)gmail(dot)com>
Cc: PostgreSQL Bugs <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: BUG #3376: Erro : COMMIT
Date: 2007-06-08 14:46:29
Message-ID: 46696BC5.4030305@enterprisedb.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Please keep the list CC'd so that others can help and learn from the
discussion.

Felipe Nogueira wrote:
> How I commit? I have a function that it will insert into a table, after
> all,
> I have commit.

You commit after calling the function. Like this:

BEGIN;
SELECT data(1,2);
COMMIT;

--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2007-06-08 14:54:26 Re: [PATCHES] [BUGS] BUG #3326: Invalid lower bound of autovacuum_cost_limit
Previous Message Alvaro Herrera 2007-06-08 14:41:42 Re: [PATCHES] [BUGS] BUG #3326: Invalid lower bound of autovacuum_cost_limit