Re: sql insert function

Поиск
Список
Период
Сортировка
От Chris Ochs
Тема Re: sql insert function
Дата
Msg-id 02e901c3d9fd$36200fd0$250a8b0a@chris
обсуждение исходный текст
Ответ на sql insert function  ("Chris Ochs" <chris@paymentonline.com>)
Ответы Re: sql insert function
Список 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@megazone.bigpanda.com>
To: "Chris Ochs" <chris@paymentonline.com>
Cc: <pgsql-general@postgresql.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?
>
>


В списке pgsql-general по дате отправления: