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 по дате отправления: