Using TEMP ON COMMIT DROP, but need logging too.

Поиск
Список
Период
Сортировка
От Michael Moore
Тема Using TEMP ON COMMIT DROP, but need logging too.
Дата
Msg-id CACpWLjNTwfGmx+atGRRC0yuwmiRAkHYr-sorzM1-Xrt5Kyd2OQ@mail.gmail.com
обсуждение исходный текст
Ответы Re: Using TEMP ON COMMIT DROP, but need logging too.  ("David G. Johnston" <david.g.johnston@gmail.com>)
Re: Using TEMP ON COMMIT DROP, but need logging too.  (Benjamin Dietrich <b.dietrich@uni-tuebingen.de>)
Список pgsql-sql
Дерево обсуждения
I've written a function that uses several temporary tables with the ON COMMIT DROP option. This function does no updates to the database. Now I would like to put in some logging. In otherwords:

insert into my_logging_table values (...);
commit;

Obviously I can't do the commit without dropping my temp tables. 

What is a good way to implement my intended functionality?

Thanks, Mike


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

Предыдущее
От: Adelo Herrero Pérez
Дата:
Сообщение: Re: How to get the position of each record in a SELECT statement
Следующее
От: "David G. Johnston"
Дата:
Сообщение: Re: Using TEMP ON COMMIT DROP, but need logging too.