Re: [SQL] MAX() of 0 records.
Paul McGarry <paulm@opentec.com.au>
From: Paul McGarry <paulm@opentec.com.au>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-bugs@postgresql.org
Date: 2000-07-07T05:34:13Z
Lists: pgsql-bugs, pgsql-hackers
Attachments
- ctidnulltest.out (application/x-unknown-content-type-out_auto_file)
- ctidnulltest.sql (application/x-unknown-content-type-sql_auto_file)
Tom Lane wrote: > 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? I've attached it here, along with the output I see. I am running 7.0.2 and the problem occurs on both my x86 Linux and Sparc Solaris installations. In addition to the output attached the postmaster console adds: ==== DEBUG: Last error occured while executing PL/pgSQL function setentrystats DEBUG: line 4 at SQL statement ==== Thanks, -- Paul McGarry mailto:paulm@opentec.com.au Systems Integrator http://www.opentec.com.au Opentec Pty Ltd http://www.iebusiness.com.au 6 Lyon Park Road Phone: (02) 9878 1744 North Ryde NSW 2113 Fax: (02) 9878 1755