Обсуждение: 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?

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

> 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)