From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Paul McGarry <paulm(at)opentec(dot)com(dot)au> |
Cc: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: MAX() of 0 records. |
Date: | 2000-07-07 03:29:42 |
Message-ID: | 8477.962940582@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs pgsql-hackers pgsql-sql |
Paul McGarry <paulm(at)opentec(dot)com(dot)au> writes:
> However there will be situations where there are no records for
> a given item_entry_id with item_live='t'. Currently when I try
> do update/insert a record so that this occurs I get the following
> error 'ERROR: ExecutePlan: (junk) 'ctid' is NULL!' and the
> insert/update attempt is rolled back.
This seems like a backend bug to me, but being an overworked hacker
I'm too lazy to try to reconstruct the scenario from your sketch.
Could I trouble you to submit a formal bug report with a specific,
hopefully compact script that triggers the problem?
> Is there a good way of going about this or should I just be wrapping
> the whole thing up in an
Until I've isolated the bug I don't want to speculate about whether
it'll be reasonable to try to back-patch a fix into 7.0.*. Usually
we don't risk back-patching complex fixes into stable releases, but
the fix might be simple once we know the cause.
regards, tom lane
PS: I trust you're using 7.0.* ?
From | Date | Subject | |
---|---|---|---|
Next Message | Paul McGarry | 2000-07-07 05:34:13 | Re: [SQL] MAX() of 0 records. |
Previous Message | Paul McGarry | 2000-07-07 01:44:15 | MAX() of 0 records. |
From | Date | Subject | |
---|---|---|---|
Next Message | Chris Bitmead | 2000-07-07 04:09:27 | Re: Alternative new libpq interface. |
Previous Message | Bruce Momjian | 2000-07-07 03:26:59 | Re: Memo on coding practices: strcmp() does not yield bool |
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2000-07-07 05:30:40 | Re: lztext and compression ratios... |
Previous Message | Paul McGarry | 2000-07-07 01:44:15 | MAX() of 0 records. |