| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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!
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Carlos Ojea Castro | 2004-06-22 15:19:28 | : can only make queries to one table |
| Previous Message | Michael Meskes | 2004-06-21 06:38:55 | Re: Interesting ECPG error |