t;
To:
Cc: "A.j. Langereis" <[EMAIL PROTECTED]>
Sent: Tuesday, November 22, 2005 2:54 PM
Subject: Re: [GENERAL] Rule appears not to fire on insert w/ "except"
> On Tuesday 22 November 2005 08:34 am, A.j. Langereis wrote:
> > Dear Chris,
> >
> > What abou
On Tuesday 22 November 2005 08:34 am, A.j. Langereis wrote:
> Dear Chris,
>
> What about this:
>
> insert into test1
> select id, data from test2
> where id, data not in (select id, data from test1);
>
> of which one would expect the same results...
>
> Yours,
>
> Aarjan
>
> Ps. notice that
Message -
From: "Chris Kratz" <[EMAIL PROTECTED]>
To:
Cc: "Jerry Sievers" <[EMAIL PROTECTED]>
Sent: Tuesday, November 22, 2005 2:12 PM
Subject: Re: [GENERAL] Rule appears not to fire on insert w/ "except"
> On Monday 21 November 2005 08:05 pm,
On Monday 21 November 2005 08:16 pm, David Fetter wrote:
> On Mon, Nov 21, 2005 at 08:05:19PM -0500, Jerry Sievers wrote:
> > Chris Kratz <[EMAIL PROTECTED]> writes:
> > > Hello All,
> > >
> > > We have finally tracked down a bug in our application to a rewrite rule
> > > on a table. In essence, t
On Monday 21 November 2005 08:05 pm, Jerry Sievers wrote:
> Chris Kratz <[EMAIL PROTECTED]> writes:
> > Hello All,
> >
> > We have finally tracked down a bug in our application to a rewrite rule
> > on a table. In essence, the rewrite rule in question logs any inserts to
> > another table. This w
On Mon, Nov 21, 2005 at 08:05:19PM -0500, Jerry Sievers wrote:
> Chris Kratz <[EMAIL PROTECTED]> writes:
>
> > Hello All,
> >
> > We have finally tracked down a bug in our application to a rewrite rule on
> > a
> > table. In essence, the rewrite rule in question logs any inserts to
> > anothe
Chris Kratz <[EMAIL PROTECTED]> writes:
> Hello All,
>
> We have finally tracked down a bug in our application to a rewrite rule on a
> table. In essence, the rewrite rule in question logs any inserts to another
> table. This works correctly in all cases except where an "except" clause is
>
Hello All,
We have finally tracked down a bug in our application to a rewrite rule on a
table. In essence, the rewrite rule in question logs any inserts to another
table. This works correctly in all cases except where an "except" clause is
used in the insert statement. In this case, the rows
On Monday 21 November 2005 03:35 pm, you wrote:
> Chris Kratz <[EMAIL PROTECTED]> writes:
> > CREATE OR REPLACE RULE debug_rule AS
> > ON INSERT TO test1
> >do INSERT INTO test_que (row_id)
> > VALUES (new.id);
>
> You would be a whole lot better off doing this with a trigger.
>
> > inser
Chris Kratz <[EMAIL PROTECTED]> writes:
> CREATE OR REPLACE RULE debug_rule AS
> ON INSERT TO test1
>do INSERT INTO test_que (row_id)
> VALUES (new.id);
You would be a whole lot better off doing this with a trigger.
> insert into test1
> select id,data from test2
> except select id,
First version of this I sent this morning did not appear to go through.
Please disregard if you received the first one.
-- Original Message --
Hello All,
We have finally tracked down a bug in our application to a rewrite rule on a
table. In essence, the rewrite rule in quest
11 matches
Mail list logo
