Re: BUG #3587: EXECUTE and trigger problem [VASCL:A1226546842]

From: Cyrus Downey <cdowney(at)pryermachine(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Alvaro Herrera <alvherre(at)commandprompt(dot)com>, pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #3587: EXECUTE and trigger problem [VASCL:A1226546842]
Date: 2007-08-30 13:59:32
Message-ID: 46D6CD44.7080000@pryermachine.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
but the documentation does not say I shouldn't be able to do it.&nbsp;
Additionally, an alternate method (which was not included) using
temporary tables works fine.&nbsp; It fails when switching to the old record.<br>
<br>
thanks<br>
cyrus<br>
<br>
Tom Lane wrote:
<blockquote cite="mid:13161(dot)1188430450(at)sss(dot)pgh(dot)pa(dot)us" type="cite">
<pre wrap="">Cyrus Downey <a class="moz-txt-link-rfc2396E" href="mailto:cdowney(at)pryermachine(dot)com">&lt;cdowney(at)pryermachine(dot)com&gt;</a> writes:
</pre>
<blockquote type="cite">
<pre wrap="">According to the documentation I should be able to use the OLD record
in the dynamic command passed to the Execute statement.
</pre>
</blockquote>
<pre wrap=""><!---->
The documentation promises no such thing.

regards, tom lane

</pre>
</blockquote>
</body>
</html>

Attachment Content-Type Size
unknown_filename text/html 1011 bytes

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2007-08-30 14:07:49 Re: BUG #3589: /etc/init.d/postgresql reload doesn't reflect /etc/postgresql/postgresql.conf log_statement
Previous Message Heikki Linnakangas 2007-08-30 11:14:20 Re: to_tsquery stack overflow