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

Re: 'execute immediate' problem

From: Michael Meskes <meskes(at)postgresql(dot)org>
To: Kamil Andrusz <wizz(at)mniam(dot)net>
Cc: pgsql-interfaces(at)postgresql(dot)org
Subject: Re: 'execute immediate' problem
Date: 2004-06-22 06:53:10
Message-ID: 20040622065310.GA5705@1 (view raw or flat)
Thread:
Lists: pgsql-interfaces
On Wed, Jun 02, 2004 at 11:15:23AM +0200, Kamil Andrusz wrote:
> Hello list,
> 
> I've go a litlle test program, that should transfer data from one db to
> another. It's just a quick hack to check if it would work at all.
> ...
> I think I'm missing something obvious. Any hints?

Yes, you program does not commit the transaction. Thus it gets rolled
back on disconnect.

Keep in mind that ecpg always opens a transaction unless you use the
command line option "-t".

Michael
-- 
Michael Meskes
Email: Michael at Fam-Meskes dot De
ICQ: 179140304, AIM/Yahoo: michaelmeskes, Jabber: meskes(at)jabber(dot)org
Go SF 49ers! Go Rhein Fire! Use Debian GNU/Linux! Use PostgreSQL!

In response to

pgsql-interfaces by date

Next:From: Carlos Ojea CastroDate: 2004-06-22 15:19:28
Subject: : can only make queries to one table
Previous:From: Michael MeskesDate: 2004-06-21 06:38:55
Subject: Re: Interesting ECPG error

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