> >> Define "executes". You could shove those lines in via the wire > >> protocol, sure, but SPI won't take them. > > > Now you really have me puzzled. What I provided is an extract from the > > log of generated SQL commands sent to the SPI interface. [Obviously > > there also values bound to the parameters which do not show up here.] > > > The code executes without error and produces exactly the output I expected. > > Are you remembering to check the result code from SPI_execute_whatever?
Of course. Every SPI call is checked and any unexpected error is trapped, resulting eventually in a call to elog(ERROR). The sequence I provided is a CREATE TABLE followed by an INSERT. The table is successfully created with the correct contents. Regards David M Bennett FACS Andl - A New Database Language - andl.org -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
