SPI_exec does not return!
| От | Markus Wagner |
|---|---|
| Тема | SPI_exec does not return! |
| Дата | |
| Msg-id | 3B55445B.36E16A4@imsd.uni-mainz.de обсуждение |
| Ответы |
Re: SPI_exec does not return!
|
| Список | pgsql-sql |
Hi, if I do a SELECT on a non-existing table, SPI_exec won't return. I get, e. g. in pgaccess, an error message "<table> does not exist", and my code below the function call is never reached. So why return error codes for SPI_exec when you cannot evaluate them? The background: I need to distinguish different client connections within a trigger function. To do this, I create a temporary table within a "login" function. My trigger must check for the existence of this function. I cannot think of any other method, since there is no "connection id" or something like that! This would also be an application for checking the existance of a temporary table, as was asked for in another thread in this list before. How can I check for the existence of a temporary table without getting interuppted????? Thanks, Markus
В списке pgsql-sql по дате отправления: