"Eric B.Ridge" <ebr(at)tcdi(dot)com> writes:
> So after upgrading from 7.2.3 to 7.3.2, I've got some interesting
> problems.
> The backend simply saysr:
> FATAL: SPI: improper call to spi_dest_setup
Yeah, 7.3.2 has some problems with rules that issue multiple commands of
the same type (like your INSERTs) :-(. This was just noticed and fixed
about a week ago:
2003-02-14 16:12 tgl
* src/backend/executor/: spi.c (REL7_3_STABLE), spi.c: Fix SPI
result logic for case where there are multiple statements of the
same type in a rule. Per bug report from Pavel Hanak.
If you pull down the latest 7.3 branch version of spi.c from
http://developer.postgresql.org/cvsweb.cgi/pgsql-server/src/backend/executor/spi.c
things should work again for you.
Sorry about that :-( ... this was an unexpected side effect of a bug fix
back in January ...
regards, tom lane