|
Problems with insert rule called from plpython: msg#00057db.postgresql.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 ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html |
|
| <Prev in Thread] | Current Thread | [Next in Thread> |
|---|---|---|
| Previous by Date: | Re: porting on ITANIUM2 platform under HP-UX: 00057, Tom Lane |
|---|---|
| Next by Date: | porting on ITANIUM2 platform under HP-UX.: 00057, Baffa Mario |
| Previous by Thread: | Re: <security/pam_appl.h> should be <pam/pam_appl.h> on MacOSi: 00057, Bruce Momjian |
| Next by Thread: | Re: Problems with insert rule called from plpython: 00057, Tom Lane |
| Indexes: | [Date] [Thread] [Top] [All Lists] |
| News | FAQ | advertise |