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

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