From: | "Chris Ochs" <chris(at)paymentonline(dot)com> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: sql insert function |
Date: | 2004-01-13 17:46:45 |
Message-ID: | 02e901c3d9fd$36200fd0$250a8b0a@chris |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Yes it was in my function. I thought the docs said that BEGIN and END had
no effect on transactions though? Plus wouldn't there have to be a
transaction active since I was not using autocommit and the inserts did in
fact commit?
I suspect it is the end statement doing this though, I'll take it out and
see what happens.
----- Original Message -----
From: "Stephan Szabo" <sszabo(at)megazone(dot)bigpanda(dot)com>
To: "Chris Ochs" <chris(at)paymentonline(dot)com>
Cc: <pgsql-general(at)postgresql(dot)org>
Sent: Tuesday, January 13, 2004 8:36 AM
Subject: Re: [GENERAL] sql insert function
>
> On Mon, 12 Jan 2004, Chris Ochs wrote:
>
> > LOG: statement: begin
> > LOG: statement: insert into...
> > LOG: statement:
> > insert into taxship(s_oid,order_id,mer_id,tax,shipping) values
> > ('0000-10000000',10000000,'0000',1,1);
> > END
>
> Where is that END coming from? Did you accidentally put it in your
> function?
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Thapliyal, Deepak | 2004-01-13 17:47:49 | Nested transaction - I am a bank ?? |
Previous Message | Chris Skaryd | 2004-01-13 17:39:47 | pg_catalog permission problem |