Problems with insert rule called from plpython

Поиск
Список
Период
Сортировка
От Pavel Hanak
Тема Problems with insert rule called from plpython
Дата
Msg-id m1znoyzzwp.fsf@pavel.brailcom.xx
обсуждение исходный текст
Ответы Re: Problems with insert rule called from plpython  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
Hello,

I've noticed one problem by upgrading from postgresql-7.3.1 to 7.3.2.
The example of this problem looks like this:

   create table test (a int, b text);
   create view testview as select * from test;

   create or replace rule testview_ins as
   on insert to testview do instead
   (
   insert into test values (1, 'a');
   insert into test values (2, 'b');
   );

   create or replace function testfun() returns text as
   '
   plpy.execute("""insert into testview values (3, ''c'')""")
   return "test"
   ' language plpython;

Now calling "select testfun()" shows this fatal error:

   FATAL:  SPI: improper call to spi_dest_setup
   server closed the connection unexpectedly
           This probably means the server terminated abnormally
           before or while processing the request.
   The connection to the server was lost. Attempting reset: Succeeded.


This example worked in postgresql-7.3.1. In postgresql-7.3.2 works only
one command used in instead:

   create or replace rule testview_ins as
   on insert to testview do instead
   (
   insert into test values (1, 'a');
   );

Can you explain me this problem? Is it possible to reply also to my
email address, since I am not member of any postgresql mailing list.
Thanks.

--
Pavel Hanak

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: porting on ITANIUM2 platform under HP-UX
Следующее
От: Baffa Mario
Дата:
Сообщение: porting on ITANIUM2 platform under HP-UX.