X-Original-To: pgsql-interfaces-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 64CDAD1B220 for ; Tue, 22 Jun 2004 03:53:24 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 50976-04 for ; Tue, 22 Jun 2004 06:53:23 +0000 (GMT) Received: from curie.credativ.org (credativ.com [217.160.209.18]) by svr1.postgresql.org (Postfix) with ESMTP id 747D8D1B18E for ; Tue, 22 Jun 2004 03:53:20 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by curie.credativ.org (Postfix) with ESMTP id 6A9D755BCA; Tue, 22 Jun 2004 08:53:21 +0200 (CEST) Received: from www.credativ.de (pD9FFE2AD.dip0.t-ipconnect.de [217.255.226.173]) (using TLSv1 with cipher EDH-RSA-DES-CBC3-SHA (168/168 bits)) (No client certificate requested) by curie.credativ.org (Postfix) with ESMTP id 6C88755BC8; Tue, 22 Jun 2004 08:53:20 +0200 (CEST) Received: from feivel (feivel.credativ.de [172.26.14.57]) by www.credativ.de (Postfix) with ESMTP id D1A951C0018; Tue, 22 Jun 2004 08:53:11 +0200 (CEST) Received: by feivel (Postfix, from userid 1000) id 716314ABBC; Tue, 22 Jun 2004 08:53:10 +0200 (CEST) Date: Tue, 22 Jun 2004 08:53:10 +0200 From: Michael Meskes To: Kamil Andrusz Cc: pgsql-interfaces@postgresql.org Subject: Re: 'execute immediate' problem Message-ID: <20040622065310.GA5705@1> Mail-Followup-To: Kamil Andrusz , pgsql-interfaces@postgresql.org References: <8765aa5nis.fsf@shwurzbung.mniam.net> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <8765aa5nis.fsf@shwurzbung.mniam.net> User-Agent: Mutt/1.5.6+20040523i X-Virus-Scanned: by AMaViS at credativ.com X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.1 tagged_above=0.0 required=5.0 tests=RCVD_IN_SORBS X-Spam-Level: X-Archive-Number: 200406/51 X-Sequence-Number: 4979 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@jabber.org Go SF 49ers! Go Rhein Fire! Use Debian GNU/Linux! Use PostgreSQL!