Stephan,
Thanks for the reply. We will be upgrading to version 8.x in the third quarter
of the year. As I said, I have a workaround. I just wanted to know why it was
behaving that way and you provided that. Thanks for the help.
On Tuesday 21 March 2006 11:36 am, Stephan Szabo saith:
> > Ok, fin
> Ok, find attached a script called test.sql that will create three tables
> called parent, child, and totals. It will create a simple AFTER UPDATE
> trigger on child and a BEFORE trigger on parent simply to show that the
> values of batch and chkno are set to NULL right in the beginning. Just loa
Ok, find attached a script called test.sql that will create three tables
called parent, child, and totals. It will create a simple AFTER UPDATE
trigger on child and a BEFORE trigger on parent simply to show that the
values of batch and chkno are set to NULL right in the beginning. Just load
the
Thanks for the response. I'm working on a simplified example now. It will take
a little time to set it up. I will post all the code for creating the much
simplified tables and trigger.
Again, thanks for the response...
On Tuesday 21 March 2006 08:15 am, Martijn van Oosterhout saith:
> On Tue,
Hello List:
I posted a question over the weekend regarding this issue but I failed to
communicate effectively what the problem is. I was weary :o[ Let me try
again.
I have a plpgsql function which makes updates to a set of records across two
tables in a One to Many relationship hereinafter re
On Tue, Mar 21, 2006 at 06:56:23AM -0500, Terry Lee Tucker wrote:
> Hello List:
>
> I posted a question over the weekend regarding this issue but I failed to
> communicate effectively what the problem is. I was weary :o[ Let me try
> again.
I think one of the reasons why you're not getting any
Terry Lee Tucker wrote:
Hello List:
I posted a question over the weekend regarding this issue but I failed to
communicate effectively what the problem is. I was weary :o[ Let me try
again.
I have a plpgsql function which makes updates to a set of records across two
tables in a One to Many
Heck, I forgot version information:
rnd=# select version();
version
--
PostgreSQL 7.4.6 on i686-redhat-linux-gnu, compiled by GCC gcc (GCC)
Hello List:
I'm having an "interesting" problem. I know what is happening, but I do not
know why; therefore, I am hoping that some of those very familiar with the
internals can/will explain it to me.
I have a function A written in plpgsql which is designed to undo changes to
several records. T
