ERROR: copyObject: don't know how to copy 704 - Mailing list pgsql-general

select
  raw.ipaddress,
  formatted.ipaddress
from
  raw ,
  formatted
where
  raw.stat_date < '2000-02-26 02:00:24-08'
  AND
  formatted > '2000-02-26 02:00:24-08'::datetime - '24 hour'::timespan
  AND
  raw.ipaddress = formatted.ipaddress;

gives this:

NOTICE:  unknown node tag 704 in fireRIRonSubselect()
NOTICE:  Node is: { IDENT "formatted" }
NOTICE:  unknown node tag 704 in modifyAggrefQual()
NOTICE:  Node is: { IDENT "formatted" }
ERROR:  copyObject: don't know how to copy 704

I recently had a crash, is this because my SQL is broken, or because
of table corruption?

I've dropped and re-created the "formatted" table (DROP/CREATE) and
this still happens.

Any ideas? (i'm using 6.5.3)

thanks,
--
-Alfred Perlstein - [bright@wintelcom.net|alfred@freebsd.org]