What does this error mean?

Started by Oliver Elphickover 27 years ago2 messages
#1Oliver Elphick
olly@lfix.co.uk

What does this mean, please?:

bray=> select * from organisation* where id in (select c.org from
org_contact as c, organisation* as o where c.contact = '100020'
and c.org = o.id);
ERROR: ExecReScan: node type 12 not supported

and how can I get round it?

bray=> \d organisation

Table    = organisation
+----------------------------------+----------------------------------+-------+
|              Field               |              Type                | Length|
+----------------------------------+----------------------------------+-------+
| id                               | char() not null                  |    10 |
| name                             | text not null                    |   var |
| address                          | int4                             |     4 |
| salutation                       | text default 'Dear Sir'          |   var |
| envelope                         | text                             |   var |
| email                            | text                             |   var |
| www                              | text                             |   var |
| contact                          | char()                           |    10 |
+----------------------------------+----------------------------------+-------+
bray=> \d org_contact
Table    = org_contact
+----------------------------------+----------------------------------+-------+
|              Field               |              Type                | Length|
+----------------------------------+----------------------------------+-------+
| org                              | char() not null                  |    10 |
| contact                          | char() not null                  |    10 |
| role                             | text not null                    |   var |
| address                          | int4                             |     4 |
+----------------------------------+----------------------------------+-------+

(PostgreSQL version 6.3.2, Linux, libc6)

--
Oliver Elphick Oliver.Elphick@lfix.co.uk
Isle of Wight http://www.lfix.co.uk/oliver
PGP key from public servers; key ID 32B8FAA1
========================================
"If ye abide in me, and my words abide in you, ye shall
ask what ye will, and it shall be done unto you."
John 15:7

#2Bruce Momjian
maillist@candle.pha.pa.us
In reply to: Oliver Elphick (#1)
Re: [GENERAL] What does this error mean?

What does this mean, please?:

bray=> select * from organisation* where id in (select c.org from
org_contact as c, organisation* as o where c.contact = '100020'
and c.org = o.id);
ERROR: ExecReScan: node type 12 not supported

and how can I get round it?

I assume this is with 6.3.2? I think this is fixed in 6.4. Beta starts
September 1.

-- 
Bruce Momjian                          |  830 Blythe Avenue
maillist@candle.pha.pa.us              |  Drexel Hill, Pennsylvania 19026
  +  If your life is a hard drive,     |  (610) 353-9879(w)
  +  Christ can be your backup.        |  (610) 853-3000(h)