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@gmx.net                   75262 Uppsala
http://yi.org/peter-e/            Sweden