Re: [GENERAL] ERROR: copyObject: don't know how to copy 704

Table schema? Data?

Alfred Perlstein writes:

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

--
Peter Eisentraut Sernanders väg 10:115
peter_e(at)gmx(dot)net 75262 Uppsala
http://yi.org/peter-e/ Sweden