From: | David Fetter <david(at)fetter(dot)org> |
---|---|
To: | Jerry Sievers <jerry(at)jerrysievers(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Rule appears not to fire on insert w/ "except" |
Date: | 2005-11-22 01:16:32 |
Message-ID: | 20051122011632.GB697@fetter.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Mon, Nov 21, 2005 at 08:05:19PM -0500, Jerry Sievers wrote:
> Chris Kratz <chris(dot)kratz(at)vistashare(dot)com> 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
> > used in the insert statement. In this case, the rows are inserted into the
> > primary table as expected, but the rule either does not fire, or fires in
> > such a way that nothing is placed in the changes table.
>
> You must be referring to something like;
>
> insert into foo
> select *
> from sometable
> except
> select *
> from someothertable
> ;
>
> If there's an EXCEPT clause on INSERT, I've never seen it.
I suppose you could wrap the SELECT...EXCEPT in parens.
WARNING Untested Code:
INSERT INTO foo
(SELECT a,b,c FROM bar
EXCEPT
SELECT a,b,c FROM baz);
HTH :)
Cheers,
D
--
David Fetter david(at)fetter(dot)org http://fetter.org/
phone: +1 510 893 6100 mobile: +1 415 235 3778
Remember to vote!
From | Date | Subject | |
---|---|---|---|
Next Message | Qingqing Zhou | 2005-11-22 01:23:56 | Re: Difference in indexes |
Previous Message | Jerry Sievers | 2005-11-22 01:05:19 | Re: Rule appears not to fire on insert w/ "except" |