Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group