inner query bug - Mailing list pgsql-bugs

I was advised to send an e-mail after a discussion with neilc on
#postgresql.

The failure occurs randomly, never on the first time (at least that I've
seen) and usually only after doing a bunch of other stuff first (big
joins, views, etc). In one case, the backend terminated and restarted,
this has only happened once.

P4 w/1024 GB ram.  RH9
uname -a
Linux gecko.paycheckadv.com 2.6.0-0.test9.1.90 #1 Tue Nov 18 09:34:47
EST 2003 i686 i686 i386 GNU/Linux

                    
psql output follows:

SC2test7=# select * from txstatus,tx txx where txstatus.txid = txx.txid
AND txstatus.statuschangetime = (select max(txstatus.statuschangetime)
from txstatus where txstatus.txid = txx.txid); FATAL:  terminating
connection due to administrator command
server closed the connection unexpectedly
        This probably means the server terminated abnormally
        before or while processing the request.
SC2test7=# \d txstatus
no connection to the server
The connection to the server was lost. Attempting reset: Succeeded.
SC2test7=# \d txstatus
                                            Table "public.txstatus"
      Column      |           Type
|                            Modifiers
------------------+--------------------------+------------------------------------------------------------------
 txstatusid       | integer                  | not null default
nextval('public.txstatus_txstatusid_seq'::text)
 statusid         | integer                  | not null
 txid             | integer                  | not null
 statuschangetime | timestamp with time zone | not null
 employeeid       | integer                  | not null
Indexes: pk_txstatus_txstatusid primary key btree (txstatusid),
         idx_txstatus_statuschangetime btree (statuschangetime)
Foreign Key constraints: fk_txstatus_statusid FOREIGN KEY (statusid)
REFERENCES status(statusid),
                         fk_txstatus_txid FOREIGN KEY (txid) REFERENCES
tx(txid),
                         fk_txstatus_employeeid FOREIGN KEY (employeeid)
REFERENCES employee(employeeid)

                    
SC2test7=# \d tx
                                          Table "public.tx"
      Column       |           Type           |
Modifiers
-------------------+--------------------------+------------------------------------------------------
 txid              | integer                  | not null default
nextval('public.tx_txid_seq'::text)
 txtypeid          | integer                  | not null
 statusid          | integer                  | not null
 amount            | numeric(6,2)             | not null
 servicecharge     | numeric(6,2)             | not null
 customeraccountid | integer                  |
 checksid          | integer                  |
 rent              | numeric(6,2)             |
 scheduledpayments | integer                  |
 txtimestamp       | timestamp with time zone | not null
Indexes: pk_tx_txid primary key btree (txid),
         idx_tx_statusid btree (statusid),
         idx_tx_txtypeid btree (txtypeid)
Foreign Key constraints: fk_tx_txtypeid FOREIGN KEY (txtypeid)
REFERENCES txtype(txtypeid),
                         fk_tx_statusid FOREIGN KEY (statusid)
REFERENCES status(statusid),
                         fk_tx_customeraccountid FOREIGN KEY
(customeraccountid) REFERENCES customeraccount(customeraccountid),
                         fk_tx_checksid FOREIGN KEY (checksid)
REFERENCES checks(checksid)

                                                                              
select * from txstatus,tx txx where txstatus.txid = txx.txid AND
txstatus.statuschangetime = (select max(txstatus.statuschangetime) from
txstatus where txstatus.txid = txx.txid);
ERROR:  variable not found in subplan target list