Re: Minor buglet in update...from (I think)

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Philip Warner <pjw(at)rhyme(dot)com(dot)au>
Cc: pgsql-hackers(at)postgreSQL(dot)org
Subject: Re: Minor buglet in update...from (I think)
Date: 2001-01-24 13:47:20
Message-ID: 200101241347.IAA12441@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


This still throws a strange error. Someone want to fix it?

>
> A minor nasty error I got when trying to improve the query used to disable
> triggers:
>
> create table t1(f1 int4, f2 int4);
> create table t2(f1 int4, f2 int4);
>
> insert into t1 values(1, 0);
> insert into t1 values(2, 0);
>
> insert into t2 values(1, 0);
>
> update t1 set f2=count(*) from t2 where t1.f1=1 and t2.f1=t1.f1 ;
> UPDATE 1
>
> update t1 set f2=count(*) from t2 where t1.f1=2 and t2.f1=t1.f1 ;
> ERROR: ExecutePlan: (junk) `ctid' is NULL!
>
> I would have expected no update to occur since no rows match.
>
>
> ----------------------------------------------------------------
> Philip Warner | __---_____
> Albatross Consulting Pty. Ltd. |----/ - \
> (A.C.N. 008 659 498) | /(@) ______---_
> Tel: (+61) 0500 83 82 81 | _________ \
> Fax: (+61) 0500 83 82 82 | ___________ |
> Http://www.rhyme.com.au | / \|
> | --________--
> PGP key available upon request, | /
> and from pgp5.ai.mit.edu:11371 |/
>

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2001-01-24 13:49:13 Re: [PATCHES] PgAccess schema-diagram cleanup
Previous Message Bruce Momjian 2001-01-24 13:45:44 Re: [GENERAL] rules on INSERT can't UPDATE new instance?