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

From: Patrick Samson <p_samson(at)yahoo(dot)com>
To: pgsql-cygwin(at)postgresql(dot)org
Subject: strace the postmaster can prevent PL/Tcl spi_exec to run correctly
Date: 2004-03-15 15:02:02
Message-ID: 20040315150202.50604.qmail@web60310.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-cygwin by date

  From Date Subject
Next Message Charl van Jaarsveldt 2004-03-15 18:43:15 Re: shmdt error
Previous Message Jason Tishler 2004-03-15 13:00:33 Re: shmdt error