strace the postmaster can prevent PL/Tcl spi_exec to run correctly

Поиск
Список
Период
Сортировка
От Patrick Samson
Тема strace the postmaster can prevent PL/Tcl spi_exec to run correctly
Дата
Msg-id 20040315150202.50604.qmail@web60310.mail.yahoo.com
обсуждение исходный текст
Список pgsql-cygwin
I needed to strace the postmaster.
Many thanks to Jason for his directions in:
http://archives.postgresql.org/pgsql-cygwin/2002-03/msg00013.php

But I noticed that in this configuration, this command
(or any SELECT, and probably any command)
didn't execute correctly in a PL/Tcl trigger:

spi_exec "SELECT getpgusername() AS connected_user"

The result is 0, and the variable isn't set.

Just for the record in the archives. I don't really
expect a fix, but can't help to think it's a very
unexpected side effect.
Better to know.


__________________________________
Do you Yahoo!?
Yahoo! Mail - More reliable, more storage, less spam
http://mail.yahoo.com

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

Предыдущее
От: Jason Tishler
Дата:
Сообщение: Re: shmdt error
Следующее
От: Charl van Jaarsveldt
Дата:
Сообщение: Re: shmdt error